record selection help

[lholodnak]

Hi, I'm new to using crystal reports and I'm using version 9. I have a need to create a report that shows only our service requests that are still open after 30 days. Not quite sure where to start. There are date fields in the database I'm using, along with an indicator to show that the service request has not been completed. Thanks, Lisa

 

[Naith]

Hey Lisa,

Sounds like what you need is something like:

{Your.CreateDate} < CurrentDate-30 and
//or {Your.CreateDate} in LastFullMonth if you prefer
{Your.Indicator} = "Open"

All the best,

Naith

 

[lholodnak]

Thanks so much, that was just what I needed. L