Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count working days within date range parameter 1

Status
Not open for further replies.

DannyBill

Technical User
Nov 21, 2005
14
US
I'm using a date range parameter {?DateRange} on my report and trying to figure out how to count the number of working days within that parameter. If anyone could help, that would be great. Please include an example.

Thanks in advance for any insight you may be able to provide.

Dan
 
I forgot..... I'm using crystal reports 9
 
Try this:
DateDiff('d', Minimum({?DateRange}) , Maximum({?DateRange}) )
- DateDiff('ww', Minimum({?DateRange}) , Maximum({?DateRange}) , crSaturday )
- DateDiff('ww', Minimum({?DateRange}) , Maximum({?DateRange}) , crSunday )


Bob Suruncle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top