Question
CR England
US
Last activity: 20 Aug 2020 18:01 EDT
How to convert UTC string date to GMT DateTime format
I have a JSON listener that gives me a string date in UTC format. My example date is: "2020-08-17T09:10:15.82". I want to be able to store this string date in a DateTime property. I have tried using:
@ParseDateStringToDate(.OpenDate)
@FormatDateTime(Primary.OpenDate,"YYYYMMdd",null,null)
@DateTime.FormatDateTime(Primary.OpenDate,"YYYYMMdd'T'HHmmsss","GMT","")
I have also tried other variations and methods. These all return 19700101T000000.000 GMT instead of their intended dates. Does anyone have a suggestion that I could try?
***Edited by Moderator: Pallavi to update platform capability tags***
Accepted Solution
Updated: 20 Aug 2020 18:01 EDT
Carelon Global Solutions
IN
Hi
you replaceall function
param.data=
@String.replaceAll(@String.replaceAll(param.date,"-",""),":","")- output 20200817T091015.82
if you dont what decimal
@String.whatComesBeforeFirst(@String.replaceAll(@String.replaceAll(param.date,"-",""),":",""),'.') 20200817T091015