Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to add a where clause in the data load editor to do the following:
Columns: ReadyDate (datetime format)
Where Ready >= Today() - 150
Thanks for any assistance.
is Francesco solution's don't work, you can try this:
Where Timestamp#(ReadyDate,'YYYY-MM:DD hh:mm:ss:fff') > Today() -150;
Yes, it's possible.
Try:
Load ReadyDate
From ...
Where Num(ReadyDate) > Today() -150;
Hi,
what is the exact format of ReadyDate field ?
The format is like:
2018-01-01 21:01:00:000
is Francesco solution's don't work, you can try this:
Where Timestamp#(ReadyDate,'YYYY-MM:DD hh:mm:ss:fff') > Today() -150;
Thanks, this seems to be working
you're welcome