Problem with dates

[#1]

Hello,

I am trying to load data to a table based on my last reload time. But my WHERE statement is not working, so I think the date format comparison isnt working because the script loads all dates. Here is my script:

LET lastReloadTime = date(ReloadTime());

Table:

Load

id,

id_user,

type,

date(date) as date

WHERE (date(date) > $(lastReloadTime));

SQL SELECT * FROM ....

Thank you,

Juan.

[tresesco · Accepted solution]

try with:

WHERE date(date) >'$(lastReloadTime)';

[#3]

Thank you!