Why power apps has a problem filtering records by date

[Anonymous]

Hi, in my case I want take from database items and I write this formula:

Sort(
Filter(
        TABLE,
        ID = "a",
        QTY > 0,
        STATUS = 1,
        SCHED = "plan",
        PHYSQ > 0,
        ITEM = DataCardValue3.Text,
        DATE >= Today()
)
,DATE)

and in that case, the formula doesn't work, only power apps keep loading something. But when I delete DATE >= Today() from the formula it works and gives me some records.

When I write such a condition, it returns these dates in the gallery to me anyway:

Date <> DateValue("01/01/1900 00:00")

Please help @timl @WarrenBelz @BCLS776 @Pstork1 @RandyHayes 

[Pstork1]

What Data source are you using? What type of column is 'Date'?  

One potential problem is that you shouldn't name the column just 'Date'.  That is the name of a data type in most data sources and may be what is causing the confusion since it is likely a reserved word.

[Anonymous]

Is database in sql, data has got data type in dd/mm/yyyy 00:00 format. I write correctly te name of column in database.

[Pstork1]

What specific SQL data type is the column? The Power Apps connector doesn't filter on SQL DateTime columns well.  This is the footnote in the documentation.

1. Direct date filters do not work for SQL Server. However, you can create a calculated column that will work. For instance, ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date])) and then filter on the calculated number column.

SQL Server - Connectors | Microsoft Docs

[Anonymous]

So i must convert date to Number or Value  and then Filter Number?

[Pstork1]

For SQL yes.

[Anonymous]

okay, and exist some function on power app to convert date to number?

[Pstork1]

Use a combination of Text() and Value()

Value(Text(Today(),"yyyymmdd"))

[Anonymous]

unfortunately, he still shows me items dated 1/1/1900 in the gallery.

[Pstork1]

Did you add a field in the SQL table and calculate the number as the footnote suggested?  Or are you calculating it at runtime.  Doing it at runtime won't work in terms of delegation.

I suspect the entries dated 1/1/1900 have a null date in them.