Question
CNO Financial Group Inc
IN
Last activity: 17 Jun 2021 2:13 EDT
How to convert UTC date time string of inbound email to Pega date time format?
Hi, I have requirement where we need to capture the received date of the inbound email into a doc that's getting attached in the Work object. The received date of the inbound email is a string and in the format "Mon May 24 02:06:59 UTC 2021". Tried @DateTime.FormatDateTime() to convert this, "Mon May 24 02:06:59 UTC 2021" --> 5/24/2021 02:06:59 but it's not working. Can you please suggest if there's any way we can do this conversion? Thanks, Saravanan
Pegasystems Inc.
IN
Can you check if this link is helpful
https://collaborate.pega.com/question/how-convert-utc-string-date-gmt-datetime-format
Bluevoir Technologies India Private Limited
IN
Hi ,
create data transform and configure the below steps.
1. Param.Year= @substring(Param.UTCDate,@length(Param.UTCDate)-4,@length(Param.UTCDate))
2.Param.Day=@substring(Param.UTCDate,@length(Param.UTCDate)-20,@length(Param.UTCDate)-18)
3.Param.strMonth=@substring(Param.UTCDate,@length(Param.UTCDate)-24,@length(Param.UTCDate)-21)
4.Param.IntMonth=@If(Param.strMonth=="Jan","01",@If(Param.strMonth=="Feb","02",@If(Param.strMonth=="Mar","03",@If(Param.strMonth=="Apr","04",@If(Param.strMonth=="May","05",@If(Param.strMonth=="Jun","06",@If(Param.strMonth=="Jul","07",@If(Param.strMonth=="Aug","08",@If(Param.strMonth=="Sep","09",@If(Param.strMonth=="Oct","10",@If(Param.strMonth=="Nov","11",@If(Param.strMonth=="Dec","12","00"))))))))))))
5.Param.HHMMSS=@replaceAll(@substring(Param.UTCDate,@length(Param.UTCDate)-17,@length(Param.UTCDate)-9),":","")
6. Param.GMTDate=Param.Year+Param.IntMonth+Param.Day+"T"+Param.HHMMSS+".009 GMT"
Result:
UTC Date:
| Mon Apr 25 02:06:59 UTC 2022 |
GMT Date:
| 20220425T020659.009 GMT |
CNO Financial Group Inc
IN
Thanks much @M.PremChand!