why the outcome data is different between "in Database" and "not in database"

I am trying to pull out all the date that smaller than Today's date

Here is the SQL that I am using which works perfectly..

SELECT *

FROM CA_AB_CM.CALENDAR_DAY

WHERE Fiscal_Date < DATE

AND Fiscal_year = 18

When I try to pull out the same data from Alteryx under the "in-database" function, here is what I keyed in in the "filter" function and the outcome data is exactly same as the above SQL query

"Fiscal_DATE" < date

"FISCAL_YEAR" = 18

However, when I try to pull out the same data not in "in-database" , the result is DIFFERENT...

Here are the data type

Fiscal_Date === Date

Fiscal_YEAR === Int 16

When I try to key in this query into the filter function, it tells me "Parse Error at Char(20) Unknow Variable "date"

[Fiscal_DATE] <= date

[FISCAL_YEAR] = 18

It seems like Alteryx can't recognize the date so it bring all the dates out.....

Although when I use the Basic Filter function by selecting [Fiscal_DATE] , it gives me the calendar for me to select the date that I want and I can select today's date which will give me the same result.