Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have two dates fields opendate and closedate .
i need subtract open date and close date.how to do it.
May be like this:
Interval(closedate - opendate) as Diff
or using NetWorkDays()
NetWorkDays(opendate, closedate) as WorkDayDiff
May be like this:
Interval(closedate - opendate) as Diff
or using NetWorkDays()
NetWorkDays(opendate, closedate) as WorkDayDiff
Thanks
can also use the inherent number value of the date within Qlick
= Num(Date1) - Num(Date2)