Technical Questions: Exclude weekends for a particulat Date range

Print Page | Close Window

Exclude weekends for a particulat Date range

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10829
Printed Date: 02 May 2024 at 10:04am

Topic: Exclude weekends for a particulat Date range

Posted By: a4chan
Subject: Exclude weekends for a particulat Date range
Date Posted: 13 Aug 2010 at 6:31am

Hello,

I am working on a report and I need to exclude weekends(i,e saturday and sunday) for a date range.Can anyone tell me how this could be done.

Thanks

-------------
a4chan

Replies:

Posted By: DBlank
Date Posted: 13 Aug 2010 at 11:28am

you mean you do not want to pull rows of data that have a date of a Sat or sunday or do you mean you want to calculate datediff excluding weekends?

Posted By: a4chan
Date Posted: 16 Aug 2010 at 10:06am

I dont want to pull rows of data that have a date sat or sun.

-------------
a4chan

Posted By: DBlank
Date Posted: 16 Aug 2010 at 10:29am

not(weekday({table.Date}) in [1,7])

Posted By: a4chan
Date Posted: 17 Aug 2010 at 8:13am

thanks

-------------
a4chan

Print Page | Close Window