Date Format

[Halebabür]

Hello, In the script section, I want to find the ones whose creation date is greater than 01.01.2021 How can I find ?

example the following statement did not work :

Load

*,

resident A

Where LastDate>'01.01.2021' ;

[brunobertels]

hi try this 

Load

*,

resident A

Where YourdateFieldhere>'01.01.2021' ;

[Halebabür]

Hello, I wanted to express this in the example. However it doesn't work

[vinieme12 · Accepted solution]

What is exact format of this field "Lastdate" ?

Is the field actually a datefield or a timestamp field

Try using below 

Where floor(LastDate)>Floor(Date#('01.01.2021','DD.MM.YYYY'));

or

Maybe it's getting loaded as text instead of date?

In this case you would need to specify the actual value format of the LastDate field

Where floor(Date#(LastDate,'EnterFormatHere'))>Floor(Date#('01.01.2021','DD.MM.YYYY'));

[Halebabür]

Thank you 🙂 You saved my day.