Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Cloud and Server

Convert Date from UTC to local time (xls template)

Question

Views

Comments

sumanths Rank 3 - Community Apprentice

May 2017 in Oracle Analytics Cloud and Server

Convert Date from UTC to local time (xls template)

We have an excel template that has few date columns.

We have an issue with the dates jumping to next day - if GMT is on next day vis a vis the transaction time.

We can cast the date in query, but would like to know if there is a way to convert in xls template.

How can we mimic <?format-date:SYSDATE;'LONG_TIME'?> in excel template?

Thank you!