Date formatting in RTF template: Excel Preview

Question

Summary

Content

Hi All,

i have a date field auth_date as dd/MM/yyyy in rtf template, PDF preview gives expected output (i.e. auth_date as 23/Oct/2017) but excel preview gives same date in dd-MMM-yy format.

but i need dd/MMM/yyyy as date format in excel as well.

PDF output:

excel output:

any suggestion???

P.S: don't want to use Excel template as it does not support custom formatting and matrix table coding

Thanks and Regards,

Zeenat Shaikh

Venkat Thota - BIP · Answer

Try this

to_char(auth_date,'dd/mon/yyyy')

Zshaikh · Answer

Issue is solved.

have added two spaces at the end of date format and finally excel is taking it as string.

to_char(pu.createdate,'DD-MON-YYYY  ')

Regards,

Zeenat

Zshaikh · Answer

Hi Tim,

thanks for reply, actually i had already tried using to_char in sql but unfortunately excel still recognizing it as date and displaying it in dd-MMM-yy

Regards,

Zeenat