Conversion of Timezone in RTF template
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