Filtering data from 6pm day before

[Former Member]

It's been years since I touched Crystal reports. Now I need to schedule a report that would only pull data from 6pm the day before. I'm not sure how to get this to work. Any suggestion would gladly be appreciated. Thank you.

[abhilash_kumar · Accepted solution]

Hi Carlos,

Use a record selection formula to bring back records after 6 pm:

{datetime_field} >= cdatetime(currentdate-1,ctime(18,0,0))

Hope this helps!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Thanks, it did the trick.