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
Post a Comment