SSRS Static Date Expression

Question

I'm creating an SSRS report and I need to set a begin date so that it always returns 12/21/2015. Is there an expression to use in SSRS to bring back a static date that will never change?

I've been chewing on this for awhile and searching everywhere. Thanks

Make the date parameter default expression =CDate("12/21/2015") — R. Richards, Nov 10 '16 at 23:36

alejandro zuleta · Accepted Answer · 2016-11-11T22:12:57.577

In SSRS you can produce date objects manually using CDATE and DATESERIAL functions.

To produce today date manually you can use:

CDATE("2016-11-11") --> yyyy-MM-dd
or
DATESERIAL(2016,11,11) --> year, month, day

And you can use them in any SSRS expression, i.e:

=IIF(Today()=CDATE("2016-11-11"), some crazy expression, some crazy expression)

or

=IIF(Today()=DATESERIAL(2016,11,11), some crazy expression , some crazy expression)

Let me know if this helps.

SSRS Static Date Expression

1 Answers1