Calculate Business Days in a Query? (1 Viewer)

[maacky99]

I have downloaded the zip file by Pat Hartman with useful date functions (thanks Pat!)

My question is; how can I use one of those modules in a query in my database? I have a Datediff field that only returns the actual number of days - after seeing the "Calculate Business Days" module from Pat I wondered if there was a way to do that in my query?

Thanks

 

[Mile-O]

Assuming:

• You want to call the new field BusinessDays
• The function is called CalculateBusinessDays
• You have two fields called StartDate and EndDate

Add a calculated field to your query:

BusinessDays: CalculateBusinessDays([StartDate], [EndDate])