I need date time value in timezone format in email body, but it always displaying in GMT although I am passing correct value from PV(date time).
E.g
pv!sla= 25/06/2019 12:00 , requirement : 25/06/2019 12:00 should display on email
if I am a honk-honk user, the value get converted into GMT and show as below
on email displaying : 25/06/2019 04:00 GMT+00:00 .
Kindly suggest with this issue, if anyone have experienced the same.
Discussion posts and replies are publicly visible
Hi
Please use the below code.
=text( pv!Date_txt, "mm/dd/yyyy hh:mm" )
Hi Ankita,
Thanks for your comments, but this one is not work , even i tried with toString(pv!sla), still getting GMT value.
Abrendra Singh.:)
tostring() will not work. Did you put the date format in text() function?