How to convert "20160922T040000.000 GMT" to 09/22/2016?
Hello All,
How to convert "20160922T040000.000 GMT" to 09/22/2016?
Thanks in Advance!
***Updated by moderator: Lochan to create new post from this comment; add topic categories***
Posted: 3 years ago
Posted: 3 years ago
Try this : @DateTime.FormatDateTime(<your property>,"yyyy-MM-dd","America/New_York","en_US")
Posted: 3 years ago
How to convert "20160922T040000.000 GMT" to 09/22/2016?
Actually I am trying write function using input type 'DateTime' and return type 'Date' SOURCE is "trunc({1})" I am getting one day less like "09/21/2016" but I need 09/22/2016.
Please try @DateTime.FormatDateTime(.pxCreateDateTime,"MM/dd/YYYY",GMT,""). Replace pxCreateDateTime with the name of the date time property that you have. Please take care of timezone and locale parameters.