How to convert from PEGA time stamp to Mar 12, 2018
I want to convert current timestamp to this (Mar 12, 2018 ) format. Tried below but it is not working.
@String.trim(@String.substring(@DateTime.FormatDateTime(@DateTime.addToDate(@getCurrentTimeStamp(), "-1", "0", "0", "0"), "DDMMYYYY", null, "CST"),0,12))
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Optum
IN
Hi Susan,
Thank you !
I was able to successfully do it with below. Requirement was to get one day prior to current date.
(@FormatDateTime(@DateTime.addToDate(@getCurrentTimeStamp(), "-1", "0", "0", "0"), "MMM dd, YYYY", null, "CST"))
Thanks,
Rahul
Updated: 13 Mar 2018 2:16 EDT
Pegasystems Inc.
US
Hi Rahul,
I followed your use case and tried to use the format of "mmm dd, yyyy hh:mm a". But I received an invalid datetime format exception. So, I didn't successfully convert current timestamp to the format of "Mar 12, 2018".
@DateTime.FormatDateTime(.DateTimeToUse, "mmm dd, yyyy hh:mm a", .TimeZoneToUse, .LocaleToUse)
Have you checked OOTB control , 'pxDateTime'?
Its 'DateTime Format' is a list of drop down. You can select the format of "Jan 1, 2001 1:00:00 AM".
Thanks,
Susan
Accepted Solution
Optum
IN
Hi Susan,
Thank you !
I was able to successfully do it with below. Requirement was to get one day prior to current date.
(@FormatDateTime(@DateTime.addToDate(@getCurrentTimeStamp(), "-1", "0", "0", "0"), "MMM dd, YYYY", null, "CST"))
Thanks,
Rahul