How to subtract two dates

[#1]

hi

i have two dates fields opendate and closedate .

i need subtract open date and close date.how to do it.

[sunny_talwar · Accepted solution]

May be like this:

Interval(closedate - opendate) as Diff

or using NetWorkDays()

NetWorkDays(opendate, closedate) as WorkDayDiff

[#3]

Thanks

[#4]

can also use the inherent number value of the date within Qlick

= Num(Date1) - Num(Date2)