Days between

[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

 

[Madawc]

In Crystal 8.5, you can get days by

DateDiff ("d", date1, date2)

Working days is a little harder. You can identify weekends using DayOfWeek (date), Saturnday is 7 and Sunday is 1. But to allow for bank holidays etc. you'd really need to add a table of dates to your database.

Madawc Williams
East Anglia, Great Britain

 

[vidru]

Here's a link to a formula from Ken Hamady's site:

http://www.kenhamady.com/form01.html

-dave

 

[synapsevampire]

I would suggest creating a Periods table to resolve these types of issues long term, here's a link to a FAQ for creating one in SQL Server:

faq767-4532

-k

 

[i257156]

Thanks guys...
Vidru's post sorted me out.
Cheers
JB