reporting services - How to get specific date based upon current year in ssrs -


can tell me how specific date based upon current year in ssrs report parameters.

ex: if current year 2016 want date field populate 31-dec-2014, if current year 2017 should 31-dec-2015, if current year 2018 should 31-dec-2016, etc.

try:

=dateserial(today.year-2,12,31) 

let me know if helps.


Comments