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.
Yes, it's possible.
Where Num(ReadyDate) > Today() -150;
what is the exact format of ReadyDate field ?
The format is like:
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
Retrieving data ...