Question format date runtime

hello,
how can I change the date format of the runtime variable: {/CORE_END_DATE}?
I tried some expressions but it does not work

to_char('${/CORE_END_DATE}$','YYYYMMDD')
and
to_char(to_date(to_char('${/CORE_END_DATE}$'),'yyyy/MM/dd HH:mm:ss:SSS'),'YYYYMMDD')

thanks for your help
Asma

Hi,

The variable value of CORE_END_DATE is set at the end of the session only. This is must be why your expressions do not work.
Are you using an Oracle database in your mapping? What do you want to do exactly?
We can give you an exemple if needed.

Vincent

Hello,

Go through below thread.

stambia.org/forum/general-questions/172-...re-end-date-variable

Regards,
Prashant