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
cindyfillerAsked:
Who is Participating?
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.

Eugene ZCommented:
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
0
cindyfillerAuthor 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,
0
Eugene ZCommented:
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
https://www.mssqltips.com/sqlservertip/1922/working-with-report-snapshots-in-sql-server-reporting-services-ssrs/
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

cindyfillerAuthor 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.
0
Eugene ZCommented:
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?
0
cindyfillerAuthor 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.
0
Eugene ZCommented:
:)
it is what the snapshot  about
It sounds like everything is working as expected
0

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
cindyfillerAuthor 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.
0
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
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.