Date Format incorrectly mapped by parse xml.
Hi All,
I am facing an issue when mapping date values returned from the service to the clipboard.
The connector returns date values in the format "yyyy-mm-dd"
However, after parsing the xml rulethe date value is mapped to a clipboard property in the format "yyyymmdd". As you can see there are no hyphens seperating the days, months and years.
Can anyone please tell me as to why this might be happening.?
Also, when i try to reformat the date value myself to the format "dd-mm-yyyy" by using substring functions and then the function todate(). The date property by default displays the value 19700101 irrespective of what date value is being returned by the service.
Any thoughts on how the above change in date format can be achieved?
***Updated by Moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***
Accepted Solution
Optus
AU
Hi Gaurav,
The default format for date property is "YYYYMMDD". Since you are using date property to store the value, PEGA is smart enough to convert to the default date format.
If you wish to store the format (dd-mm-yyyy) as it is you can use property of type text.
From the help system, (Click here)
A property of type Date can have a null value. For example, if you use the Property-Set method to set a Date type value from a Text value that is null, the result is null. However, the Java Date operations convert an integer value of 0 to the date 19700101 (January 1, 1970). This Datevalue may result when Pega 7 Platform evaluates expressions that internally use the Java Date operations.
Rules Cube Inc.
CA
Hi Gaurav,
Did you try changing to your desired date format to display it ? You can find it under presentation tab in the properties panel of that property and can be changed to customized format by selecting Custom option.
Thanks
Venkatesh G
Accepted Solution
Optus
AU
Hi Gaurav,
The default format for date property is "YYYYMMDD". Since you are using date property to store the value, PEGA is smart enough to convert to the default date format.
If you wish to store the format (dd-mm-yyyy) as it is you can use property of type text.
From the help system, (Click here)
A property of type Date can have a null value. For example, if you use the Property-Set method to set a Date type value from a Text value that is null, the result is null. However, the Java Date operations convert an integer value of 0 to the date 19700101 (January 1, 1970). This Datevalue may result when Pega 7 Platform evaluates expressions that internally use the Java Date operations.