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,

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.

Tags (2)
1 Solution

Accepted Solutions
undergrinder
Valued Contributor II

Re: No of days between two dates

Hi Raman,

try this:

=Interval(date2 - date1, 'd')

G.

3 Replies
dapostolopoylos
Contributor III

Re: No of days between two dates

Try

Num(Date1) - Num(Date2) as DateDiff

Father/Husband/BI Developer
undergrinder
Valued Contributor II

Re: No of days between two dates

Hi Raman,

try this:

=Interval(date2 - date1, 'd')

G.

rsingh43
Contributor

Re: No of days between two dates

Thanks!

Community Browser