Hi All, Anyone has got solution for this?

Hi Sumanth Use the following sample SQL: SELECT TO_CHAR(FROM_TZ(CREATION_DATE, DBTIMEZONE) at time zone (select :xdo_user_timezone from dual),'YYYY-MM-DD HH24:MI:SS ') creation_date, creation_date creation_date2, :XDO_USER_TIMEZONE, :xdo_user_name name FROM ap_invoices_all where TRUNC(FROM_TZ(creation_date, DBTIMEZONE) at…

for the RTF, I am aware <?format-date:CreationDate; 'XDODEFDATE'?> This only works for rtf template. Needs for excel template as above is not working on excel template in BIP

Hi, can anyone suggest for xls template. <?format-date:CreationDate; 'XDODEFDATE'?> This only works for rtf template. Thanks and regards Abhishek