Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

No of days between two dates

Hi,

Can someone please clarify the correct way to calculate the number of days between two dates columns in the data load editor?

Date 1: 01/01/2018 10:00:00

Date 2: Today()

Thank you in advance for any assistance.

1 Solution

Accepted Solutions
undergrinder
Specialist II
Specialist II

Hi Raman,

try this:

=Interval(date2 - date1, 'd')

G.

View solution in original post

3 Replies
dapostolopoylos
Creator III
Creator III

Try

Num(Date1) - Num(Date2) as DateDiff

Father/Husband/BI Developer
undergrinder
Specialist II
Specialist II

Hi Raman,

try this:

=Interval(date2 - date1, 'd')

G.

Anonymous
Not applicable
Author

Thanks!