Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bouderbc
Creator
Creator

How to calculate the delay (number of days) between tow differents dates ?

Hi Experts,

How to calculate the delay (number of days) between two differents dates ?

Thanx a lot

Regards

Ali

3 Replies
sunny_talwar

May be just this

Date2 - Date1

YoussefBelloum
Champion
Champion

Hi Ali,

If you want simply the number of days you can substract the first Date from the second.

But if you want the number of working days, you can use NetworkDays() function in the same way.

HirisH_V7
Master
Master

May be this,

Ceil(Interval(Date#(DateField2, 'MM/DD/YYYY hh:mm:ss') - Date#(DateField1, 'MM/DD/YYYY hh:mm:ss'), 'DD' ))

or

simply This,

Ceil(Interval (Date2-Date1,'DD'))

*Above ,You can mod according to your date format.

HTH,

Hirish

HirisH