Formula for past 24 hours

[granny1]

I need help with a formula for all events that have occured within the past 24 hours. If I use Current Date -1 I get duplicate data.

 

[idle]

What is your record selection formula?
By "duplicate data", do you mean two copies of each record, or records for two full days, or something else?

 

[granny1]

WHEN I DO {LSC-MIS_Operations.Create-date}>= CurrentDate -1
MY REPORT SHOWS DATA FOR THE 16TH AND THE 17TH THE NEXT TIME IT RUNS IT SHOWS THE 17TH DATA AGAIN PLUS DATA FOR THE 18TH

 

[kenhamady]

That sounds correct. The "past 24 hours" would include some records from today and some from yesterday. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kenhamady]

If you have a DateTime field you could try:

CurrentDatetime - 1 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[granny1]

Thanks for the information Currentdatetime corrected my problem