It took me quite a while to set up a series of snapshots on the report server so I don't want to redo them if possible. I found that the end date for these snapshots had the incorrect date. I need the end date to be today's date. When I'm working in Bids I can easily change it to today(). But changing it in Bids and then republishing it does not affect the snapshots and the snapshot must have a static parameter. I tried to just enter today() or several other variations and it won't accept those in the parameters on the report server. Is there a way around this?
When I try today() or any other option that provides todays date I get the following error: The value provided for the report parameter 'EndDate' is not valid for its type