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

[bouderbc]

Hi Experts,

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

Thanx a lot

Regards

Ali

[sunny_talwar]

May be just this

Date2 - Date1

[YoussefBelloum]

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]

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