Need MonthtoDate without weekends

[glarkin]

I'm selecting records for my report using MonthtoDate but I want to exclude the weekends. Is this possible using Crystal 10?

Thanks!

 

[kutoose]

You may try the function DayofWeek().By default the DayofWeek() returns 7 for Saturday and 1 for Sunday.

So something like not(DayofWeek(Date) in [1,7])

 

[dgillz]

Sure, try this:

{YourDateField} in Monthtodate and
day({YourDateField}) in 2 to 6

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz