Format Date Parameter in Report Expression

[boognish]

Hi All,
I have a date parameter I'd like to format as 'Month Year' within a report expression. Parameter is a date, and I'd like it to display as 'January 2017' in my report expression.

to_char(
timestamp2date (
string2timestamp (ParamDisplayValue('Date_Param') ) )
,'Month') 

I seem to be getting hung up on the to_char part - any advice would be greatly appreciated!

error:
CRX-API-0011 The function name was not found at or near the position '7' in expression: "to_char(
timestamp2date (
string2timestamp (ParamDisplayValue('Month_Param') ) )
,'Month')



Thanks.

[Kiran Kandavalli]

Can you create the same expression in a Data item and drag it as a single ton. As some of the function we cannot do it in Report expression