Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How to calculate the delay (number of days) between two differents dates ?
Thanx a lot
Regards
Ali
May be just this
Date2 - Date1
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.
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