Question

14
Replies
3883
Views
JimG8088 Member since 2015 23 posts
Centene
Posted: April 17, 2015
Last activity: July 17, 2017
Closed
Solved

Default Report Parameters to Current Date (or some function)

Hello everyone,

I am building a report, with parameters for a date range - StartDate, EndDate, that kind of thing. I see the Parameters Tab has a "Default Value" box, but it seems that it does not want to accept a formatting or function value such as

@FormatDateTime(@CurrentDateTime(), "MM-dd-yyyy", "EST", "")

I don't want to hard code in an ACTUAL date, but rather, am trying to find a way to make the default value be something like "Current Date", or "1st day of current month", etc. Can i put in a date function in the DefaultValue?

Default Dates.PNG

***Updated by moderator: Marissa to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Reporting
Moderation Team has archived post
Share this page LinkedIn