macro prompt not getting refreshed in scheduled report

[kiran.timsina]

I have a date prompt which is set to default to today's date using a prompt macro. Then I minus it by 1 using javascript to default it to yesterday's date. The report is scheduled to run daily using today's date but every day it runs it takes the date of one day before the report was scheduled. My schedule says to run the report and not just view the report. How do I schedule a report to run using refreshed dates? (cognos 10.1.1)