How do you setup the Scheduler to run a report on the last day of the month. The end of the month can be a range between the 28th and 31st of the respective month. Many thanks in advance.
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi Blair,
There actually is no way to create a single scheduled task to run a report on the last day of the month via the scheduler. This is a limitation of the Windows task scheduler which is what the Jet scheduler uses. You can work around this several ways. You can make 3 separate scheduled tasks (one for months that end on the 31st, one for months ending on the 30th, and one for the 28th). Another thing you can do is schedule the report to run on the 1st of the month at midnight or schedule it to run on the first of the month but set a date filter on your report which uses NOW() - 1. Does this help?
Regards,
Hughes
Please sign in to leave a comment.