Excluding Specific Days from Report

[IKONOS]

Is there a formula to extract a date range from a report?

Trying to capture records starting 06/01/2001 through 06/22/2001 and then picking back up again on 06/26/2001 until 06/30/2001.

Any simple way to do this?

Thanks!

Mark

 

[kenhamady]

Here is one simple way.
If you go to the selecte expert you can set up one 'between' rule for the first date range. Then click "show Formula" to see the syntax. You can then copy the syntax and make a second rule, using an "OR" between them. It will look something like:

{date} in Date (2001,06,01) to Date (2001,06,22)

or

{date} in Date (2001,06,26) to Date (2001,06,30) Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[IKONOS]

Thanks for the quick response Ken!
Shortly after posting this message I figured it out! Exactly the way you suggested!

Thanks again!

Mark