I know how to export a file as excel and put todays date in the file name, but I need a date from within the database. When we run our orders report, its runs one business day after the orders are placed. So Monday's orders go on Tuesday's reports. OK easy, use todays date -1. When running the report on Monday for Fridays orders, its a little more complicated but I can figure it out. But its not always that simple. Holidays or other days off complicate it and have me stumped. If its a three day weekend, we run Fridays report on Tuesday.
Within the report itself, its easy, I set up a prompt so I have to enter the date the reports are for. Is it possible to use this same prompt or something else to apply the correct date to the file name when exported as an excel file?
Thanks in advance!