Date Period 'Yesterday' question 1

[snazzyCrunch]

I am using CR8.5. I have a report automatically running every night b/n 02:00 and 02:30 AM.

I would like the report to only report on data with Yesterday's timestamp.

I tried the formula:
not({myField.DATETIME} in AllDaysToYesterday)

Also, data does not get written to the db until around 10 at night. So, I know that if I could write a formula that is the equivalent of....

Select....
From.....
Where {myField.DATETIME} >= Yesterday's Date

Has anyone done this before?

Thanks in advance!
snazzyC.

 

[chelseatech]

What about
Date({table.datetimefield}) = CurrentDate -1 Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm