Converting a number like 2019 from a numeric parameter into a calculated column date (YYYY) format

[Hessam]

Hi All

I have a numeric number like 2018 fed from a slider bar into a numeric parameter (year_parameter). 

I'd like to convert the value into a date year (YYYY) format in a new calculated column and then use the new calculated column as a filter criteria for the object in my report. 

Any idea how to do this?

[Sam_SAS]

Hello,

In 8.2 and later you can make date-based parameters, which would simplify things.

Otherwise, you can create a date value using a calculated expression like this:

DateFromMDY(1, 1, 'Parameter 1'p)

This will create values like '01 January 2018', but you can set the format of this data item to show the year only.

Let us know if this helps!

Thanks,

Sam