Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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' ;
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'));
hi try this
Load
*,
resident A
Where YourdateFieldhere>'01.01.2021' ;
Hello, I wanted to express this in the example. However it doesn't work
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'));
Thank you 🙂 You saved my day.