Changing the date

[tinmar]

I am currently running a report which includes say today, and I have made it schedule. Im trying to schedule it to run each day at a certain time, how would I make the report auto change the date for the next day, eg today being the 2003-06-03, my report tomorrow will auto run the 2003-06-04

 

[Mailpack]

To get the data in the report to change, use a date selection field compared to the function today.

This will then filter the data on the report to only show the current date.

You can either include the date field as a column on the report, or include the today field in the report header

 

[drlex]

Tinmar,
Be careful if you are filtering a lot of data - use of today() or now() in the impromptu filter can result in the filtering being done on the PC, rather than the DB. You can check this by looking at the SQL generated - no date = local processing. I found that using a prompt in the filter and passing the current date from a macro in scheduler maximises the speed.
HTH,
Lex