=-( How do I exclude weekend days on reports

[jolie555]

I am writing a report where I am using a specific date criteria for elapsed days and need to exclude weekends. Help!

 

[BlurredVision]

Dayofweek({Datefield}) Not in [1,7] Brian

http://www.crystalcommunity.com

 

[IdoMillet]

See:

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

hth,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:

http://www.MilletSoftware.com

 

[jolie555]

I tried doing this and it is giving me an error stating that there is an error in the formula.

 

[dgillz]

Blurred vision was close. Try this:

Not (Dayofweek({DateField}) in [1,7]) Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[dgillz]

Or you can use:

DayofWeek({Datefield}) in 2 to 6 Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com