Conversion of Timezone in RTF template — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conversion of Timezone in RTF template

edited Apr 9, 2020 7:05AM in Reporting and Analytics for HCM 1 comment

Content

I am facing a situation where the client is entering the data in the UI as 9:00 AM but since the database stores the time in the UTC format it is storing as 13:00 hours. Now I want to convert this to client timezone in the RTF template.

I have been trying to use the format date function in RTF template but its not working.

<?format-date:XML_TAG_FOR_DATETIME;'hh 12:mi PM';'EST'?>

but this is giving me 8:00 AM.

The client is in EST timezone. Can anyone please suggest some solution to this.

Thanks and Regards,

Amrit

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!