Parsing date from dd/mm/yyyy string
I have a string which contains date in dd/mm/yyyy format which I am trying to set into a datetime property. But I get an invalid date format error on commit call of activity. I have tried converting the above string in a valid date format by using different functions but all I get is 19700101 date. How can convert it properly?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
ai4process
GB
This is fixed by setting correct locale value in operator profile. We had en-GB and on pega 7.1.8, changing this to en_GB resolved the issue.
BUPA
AU
19700101 comes if the value for the date parameter into the function becomes NULL. Please check whether correct value is being passed or not. Kindly share what function is being used with screenshot.
ai4process
GB
Yes. I have checked that the value is being passed. I'm using @DateTime.FormatDateTime() function and passing the same property as first parameter.
Here is a screenshot of page having the value
Here is the function used to set the value again in next step
@DateTime.FormatDateTime(RecordPage.DELIVERYDATE,"mm/dd/yyyy","","")
This is the screenshot of next step
Pegasystems Inc.
IN
You can use PRDateFormat.parseAsDateTime(null, null, format, text) method to achieve the same. Below are the details about this method.
Let us know if this helps :)
parseAsDateTime(java.lang.String aLocale, java.lang.String aZone, java.lang.String[] aPatterns, java.lang.String aValue)
Pegasystems Inc.
IN
Hi AkashVibhuti,
You can also try the below function and see if it works:
@String.toDateTime("string value")
Accepted Solution
ai4process
GB
This is fixed by setting correct locale value in operator profile. We had en-GB and on pega 7.1.8, changing this to en_GB resolved the issue.