Filtering for previous day in Impromptu 2

[jezmondo]

I have created a number of reports that show a day's transactions with a filter of 'Date Ordered = Today()'. These reports now need to be run to show the previous day's transactions. Does anyone know how to do this i.e. 'Date Ordered = Today() -1'

Cheers

 

[shearbec]

Hi Jezmondo,

This is pretty simple to do. If you begin setup the calculation as you have stated:

Date Ordered = (Today -

Then click on Values, Interval, and you'll get
000 00:00:00.000

Change it to look like 001 00:00:00.000

Your final calculation should appear to be:

Date Ordered = (Today - 001 00:00:00.000)

Hope this helps...Shearbec

 

[jbecher]

Or use:

add-days(today, -1)
-OR-
add-days(now, -1)

today = impromptu workstation date
now = database server date

HTH,

Justin