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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run monthly report for only Monday thru Thursday and another monthly report for Friday

Status
Not open for further replies.

capronton

MIS
Jun 28, 2013
159
US
I would like to run two monthly reports

1) Monthly report for only Monday thru Thursday
2) Another monthly report for only Friday

I know there's a function in crystal report that does this, but I cannot find it. Can someone assist?

Thanks.
capron
 
Skip

The solution below appears to be working for the Monthly Report Mon - Thur. Still Testing.

DayOfWeek ({incident_date_time}) > 1 and
DayOfWeek ({incident_date_time}) < 6

Thanks Skip for all your help on this site!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top