convert string to datetime
Hi Team,
I have a property of type text is holding a value in format of "dd-MMM-yyyy hh:mm:ss" and this is coming from an API.
i wanted to convert this text/string to pega datetime (dd-MMM-yyyy hh:mm:ss) to use it in table layout and for sorting purpose.
i tried todatetime() but its not working as expected.
Please help on the above to parse datetime.
Thanks.
Infosys Limited
IN
Could you try using DateTime • parseDateString Function on passing the date String format? It returns the respective Date in the format.
LTIMindtree
PL
Eclatprime Digital Private Limited
IN
@uma496 Hi
Try this one
ex; A property is having a type of text and the value is "2022-07-20T11:10:15.82 "
Use this function
@String.replaceAll(@String.replaceAll(param.PropertyName,"-",""),":","") and output is :20220720T111015.82
Areteans Tech
AU
@Sai Guggilla I dont think this function will help , Usually Pega date contains GMT . I dont see the GMT in your function
Please check the below post ,
Eclatprime Digital Private Limited
IN
@uashok93 Hi
Use this approach, you can include the time format in the property value so that you can get the exact output.
ex; A property is having a type of text and the value is "2022-07-20T19:50:15.02 GMT "
@String.replaceAll(@String.replaceAll(param.PropertyName,"-",""),":","") and output is: 20220720T195015.02 GMT
Now it shows the Pega date time format. Check it once
Thank you
LTIMindtree
PL
Hi Sai, thanks for reply.
but i'm having the text type datetime of format like dd-MMM-yyyy hh:mm:ss that means "21-07-2022 13:39:00" which is coming form service (please refer attachement) so, i have to convert the above text datetime to pega datetime. please suggest on this.