Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

No of days between two dates

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.

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: No of days between two dates

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

Where Timestamp#(ReadyDate,'YYYY-MMSmiley Very HappyD hh:mm:ss:fff') > Today() -150;

6 Replies
francescoreggia
New Contributor III

Re: No of days between two dates

Yes, it's possible.

Try:

Load ReadyDate

From ...

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

YoussefBelloum
Esteemed Contributor

Re: No of days between two dates

Hi,

what is the exact format of ReadyDate field ?

rsingh43
Contributor

Re: No of days between two dates

The format is like:

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

YoussefBelloum
Esteemed Contributor

Re: No of days between two dates

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

Where Timestamp#(ReadyDate,'YYYY-MMSmiley Very HappyD hh:mm:ss:fff') > Today() -150;

rsingh43
Contributor

Re: No of days between two dates

Thanks, this seems to be working

YoussefBelloum
Esteemed Contributor

Re: No of days between two dates

you're welcome

Community Browser