Date Conversion

[Mpotla]

Hi Guys,

I have one requirement to find the last day of the fiscal Year-Month selected and I want to use this date in calculations and filters in the report. so  i have created one parameter map with Key in YYYYMM format and Value 28-NOV-2010 which is date.

Now i have created one data item with expression
#sq($[PM_Last_Fiscal_Sunday]{prompt('Param_Rptg_Period','token')})#, Which is returning date in character format.  I tried using cast() and to_date function but its throwing error.

TO_DATE(#sq($[PM_Last_Fiscal_Sunday]{prompt('Param_Rptg_Period','token')})#,'DD-MON-YYYY').

please help in resolving the issues. Thanks for your help in advance.

Regards,
Potla

[nag.prasady@gmail.com]

Hi ,
use this  to_date(To_char('your character date','ddsp mmsp yyyysp'))
let me know if it works.
Regards,
Nagendra