Question
Staidlogic
IN
Last activity: 25 Jul 2024 5:51 EDT
Convert time format from HHmmss to HH:mm:ss AM/PM
Hello everyone,
I am currently trying to fetch a time value from the data type table into a data transform using DPage. The value is currently displayed in the format (190000/HHmmss) and mapping it to a property(Text Type), and I would like to convert it into the format (07:00:00 PM/HH:mm:ss AM/PM) and map it to a "TimeOnly/TimeOfDay" type property. I've tried various solutions from PDN and the web, but I haven't been able to make the conversion successfully.
Does anyone have any suggestions or solutions they can share?
Please note that I am using the Time type property rule, not date time or date.
Thank you in advance,
Koti S
Pegasystems Inc.
IN
@Koti Reddy Sanagala we can try to use FormatDateTime function to format date time as per our requirements. the input for this would be date time. As your datetime is a string, we need to first parse it and convert it to dateTime. Please try this function and let us know the output
Carelon Global Solutions
IN
Hi @Koti Reddy Sanagala
We can use FormatDateTime Function but the input should be DateTime .In this scenario I have set the random date and formatted it as DateTime and then I have passed it to the function. So we got the output as expected.
