No of days between two dates

[Anonymous]

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.

[francescoreggia]

Yes, it's possible.

Try:

Load ReadyDate

From ...

Where Num(ReadyDate) > Today() -150;

[YoussefBelloum]

Hi,

what is the exact format of ReadyDate field ?

[Anonymous]

The format is like:

2018-01-01 21:01:00:000

[YoussefBelloum · Accepted solution]

is Francesco solution's don't work, you can try this:

Where Timestamp#(ReadyDate,'YYYY-MM:DD hh:mm:ss:fff') > Today() -150;

[Anonymous]

Thanks, this seems to be working

[YoussefBelloum]

you're welcome