Skip to Content
0
Former Member
Apr 21, 2014 at 06:10 PM

I am running many Crystal Reports that I wish to pull data from ONLY the previous day.

29 Views

I am running many Crystal Reports that I wish to pull data from ONLY the previous day. I am currently using the Select expert formula

{datefield}= currentdate-1;

I have also tried this...

{datefield} = dateadd("d",-1,currentdate);

The issue is when I run these reports it pulls data from the previous day and all data up to the moment I run the report. I only want data from the previous date from 00:00 to 23:59 of that date only not including data up until when I run the report.