Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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-MM:DD hh:mm:ss:fff') > Today() -150;

View solution in original post

6 Replies
Highlighted
Partner
Partner

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-MM:DD hh:mm:ss:fff') > Today() -150;

View solution in original post

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