Problem with run dates using Scheduler

Hi there,

I have a report set up to list out certain transactions for the day. I have it scheduled to run each evening for that day, using the "=Today()" for the date. This date also prints on the report. The report is ran and emailed to the user each evening. When he opens the report the next morning, the date printed on the report is the date he opens the report, but the data is for the previous day when the report was run. (He does not have any Jet functionality) Is there a function other than "=Today()" that can be used to run the report for that day and then print that date on the report without it changing to the date the report is opened?


Pat Rounds


Please sign in to leave a comment.