CAST function not working in Congos 10

[dust0000]

Hello Everybody,

I have a date code works well in Cognos 8.4 but cannot work on Cognos 10.

_add_months((Cast((extract(YEAR,{sysdate})||'-'||extract(Month,{sysdate})||'-16'),DATE)),-1)

Normally, I need find 16th for each month by current date. I cannot use current_date as well.

Do you have any suggestion?

Thank you very much!

[MFGF]

Hello Everybody,

I have a date code works well in Cognos 8.4 but cannot work on Cognos 10.

_add_months((Cast((extract(YEAR,{sysdate})||'-'||extract(Month,{sysdate})||'-16'),DATE)),-1)

Normally, I need find 16th for each month by current date. I cannot use current_date as well.

Do you have any suggestion?

Thank you very much!

Yes

Replace the whole expression with

_add_days (_first_of_month (current_date), 15)

MF.