Sort by previous date

[Estandridge]

I have a report in CR8.8 that I need to modify. I'm sure this is a somewhat basic question but as my version didn't come with any help files I'm at a loss.

I need the report to display values for only the previous business day by date. Currently, I have it set up as to prompt the user to enter the date, but they want to run the report daily from a remote server. All that is set up already, however, I have no idea how to have the report pick up the previous invoice date through the select expert. Any help would be much appreciated.

Thanks!
Eric

 

[kskid]

Place the following in your select expert


{invoice.date} = currentdate - 1

 

[synapsevampire]

Try the Report->Edit Section Formula->Record

{table.date} = currentdate-1

This will return the data for the previous days dates.

For all dates prior to and including the previous day, use:

{table.date} <= currentdate-1


-k

 

[lbass]

If you want to ignore weekends, then try:

if dayofweek(currentdate) = 2 then currentdate - 3 else
currentdate - 1

-LB