New to Qlik Sense

[Anonymous]

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.

[dapostolopoylos]

Try

Num(Date1) - Num(Date2) as DateDiff

[undergrinder · Accepted solution]

Hi Raman,

try this:

=Interval(date2 - date1, 'd')

G.

[Anonymous]

Thanks!