DaysBetween

[i257156]

I know that I am being really thick.. However, I need this syntax pretty quick and I haven't got time to go to the quacks to get some memory pills!

When adding a variable to count the days between is it possible to count the number of working days between? If so how the heck do you do it!!??
Thanks
JB

 

[BrianTyler]

You should test this, but I think it would work.

daysbetween=(int(days(date2) - days(date1))/7)*5 +
if dayofweek(date2) >= dayofweek(date1) then dayofweek(date2) - dayofweek(date1)
else
dayofweek(date1) - dayofweek(date2) - 2

It converts the dates to an integer number of days, treats whole weeks as 5 days, then adjusts for the differenece of day of week.

The exact syntax will depend on the database in use.