Discussion Board for collaboration related to QlikView App Development.
How to calculate the delay (number of days) between two differents dates ?
Thanx a lot
May be just this
Date2 - Date1
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' ))
*Above ,You can mod according to your date format.