This is similar to what crystalsonic was asking
The following will give you the difference in days
numbervar Daydiff;
Local DateTimeVar d1 := {Date1};
Local DateTimeVar d2 := {Date2};
Daydiff := DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday);
To get the difference in seconds you will have to
count the number of seconds in each Saturday and Sunday which is 24 * 60 * 60 or 86400
numbervar Seconddiff;
Local DateTimeVar d1 := {Date1};
Local DateTimeVar d2 := {Date2};
Seconddiff := DateDiff ("s", d1, d2) -
( DateDiff ("ww", d1, d2, crSaturday) * 86400) -
(DateDiff ("ww", d1, d2, crSunday) * 86400) ;
Seconddiff
Which youi will then have to convert back to however you want to display it
IP Logged
