Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Convert Date from UTC to local time (xls template)
sumanths
Rank 3 - Community Apprentice
Summary
Convert Date from UTC to local time (xls template)
Content
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!
0