How to get specific date based upon current year in ssrs

0
votes

Can someone tell me how to get specific date based upon current year in SSRS report parameters.

ex: if current year is 2016 I want date field to populate as 31-Dec-2014, if current year is 2017 then it should be 31-Dec-2015, if current year is 2018 then it should be 31-Dec-2016, etc.

1
reporting-servicesssrs-2008

1 Answers

2
votes

Try:

=DateSerial(Today.Year-2,12,31)

Let me know if this helps.