set parameter to current date on SSRS report server (not bids)

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
cindyfillerDirector of ITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
please clarify: what date(s) do you expect to see in, A n example, the 1  week old SSRS report snapshots?
it looks like all is working as it should
cindyfillerDirector of ITAuthor Commented:
I have the StartDate set for 7/1/15 which is good.  I want the end date to be what ever today's date is.  Right now the end date is 6/30/16 and that is wrong,
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
is it  for a new (today's)  snapshot?
what is your SSRS version?

try to use
EndDate dataset using this Sql server query "Select GetDate() as CurrentDate"

and add this expression into the report textbox ="EndDate:" + " " + First(Fields!Now.Value, "EndDate")

also check this example

Working with Report Snapshots in SQL Server Reporting Services SSRS
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

cindyfillerDirector of ITAuthor Commented:
Thank you for the article.  It seemed to be more about creating the snapshot and I've already done that.  And I have no problem changing the parameter to use today's date.  That works fine whether I'm in Bids or if I am running the report myself.  The issue is that the static parameter in the current snapshots has 6/30/16.  It won't let me change it to todays date in any way.  Changing it in Bids does not affect the current parms on the snapshots.  Right now the only work around I've found is to recreate the snapshots and that takes me hours.  I was hoping to find a way to change the parm on the snapshot itself...  

I have sql 2008 R2.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
just to be clear: after you published report and set it to create snapshots at specific date\time

Do you see  the "right" date time for 'EndDate'?

let say - do you see  the above example as a way to simulate your issue?
cindyfillerDirector of ITAuthor Commented:
After I publish the report, the end date is correct for the report in a different folder where a user can run it on demand and change the dates.  However, the correct date is never displayed on the snapshot unless I recreate the snapshot.  I was hoping for an easy way to just change the end date to today's date on the snapshot itself, but I think the only option is to recreate the snapshots.  I didn't want to spend the several hours it will take to do that.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
it is what the snapshot  about
It sounds like everything is working as expected

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cindyfillerDirector of ITAuthor Commented:
I didn't give myself any points.  In reality I realized that I won't be able to make the change to that snapshot and I'll have to recreate it.  His comment pretty much summarized this realization but my comment provided more data.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.