jrechter Wrote: After searching on how to set a daily scheduled task on a report whose date field has to default to yesterday (current day - 1), I came upon this thread, which seemingly would fix my problem, but alas, did not. When I manually run the report, I can default the End Date to the previous day, and the report runs fine, giving me the previous day's information. When I scheduled this report to run each day, I would expect the End Date to increment a day at a time, but instead, it saves the initial date that the schedule was made, and the result is that I get the same report every day. End Date is always 07/04/2009. I've played around with _ScheduledTime but have been unsuccessful. Any help would be appreciated on how to make the date parameters dynamic within scheduled tasks. Thanks. Hi, We solved this by adding some SQL to the report query to give us different scheduling options, and then you simply pass the parameter to the report for it to run (i.e. "Previous Day" or "Month to Date"). Below is the SQL as an example. -Scott Code: (CASEWHEN $P{report_schedule} = "Month to Date" THEN (DATE(NOW()) + INTERVAL 1 DAY)WHEN $P{report_schedule} = "Previous Month" THEN (DATE_FORMAT(CONCAT(YEAR(NOW()),"-",MONTH(NOW())-1,"-",DAY(LAST_DAY(NOW() - INTERVAL 1 MONTH))),"%Y-%m-%d") + INTERVAL 1 DAY)WHEN $P{report_schedule} = "Previous Year" THEN (DATE_FORMAT(CONCAT(YEAR(NOW()),"-",MONTH(NOW())-1,"-",DAY(LAST_DAY(NOW() - INTERVAL 1 MONTH))),"%Y-%m-%d") + INTERVAL 1 DAY)ELSE ($P{end_date_text} + INTERVAL 1 DAY)END)