Question
Relconsoft
NO
Last activity: 8 Aug 2016 7:36 EDT
ParseXML problem parsing date type with timezone
Hi All,
I faced with problem parsing date with ParseXML rule in Pega 7.1.9. Third-party SOAP service returns a date in format like '2001-10-26+02:00'. In parseXML rule for this element XSD Base Type is set to 'date' on Type tab. Property to map is also Date type. As a result this element is not parsed at all. I applied Hfix-28202 but it didn't help.
Any suggestions how to solve this issue?
Accepted Solution
PEG
IN
Similar kind of discussion going on regarding date is saving one day before. Please refer https://collaborate.pega.com/discussion/unable-pass-valuelist-summary-view-0
Relconsoft
NO
In accordance with W3C this format is correct. What is more - I've checked behaviour of parseXML in PRPC 6.2SP2 with this format - it worked fine.
Pegasystems Inc.
US
I suppose that a date with a time zone makes some sense. As I write this it is tomorrow in Japan. If you show that this is working in 6.2 SP2, then this may be a regression. Lets see if we get further reponse from an engineer on this. If not then we should create an SR to address it.
Relconsoft
NO
New details abount this issue. I've reproduced this situation on two other servers - Hfix-28202 really works. So, the problem is in one particular server instance. But I've noticed one odd thing - parsed value is date minus one day - e.g. '2001-10-26+02:00' became '20011025'. Not sure this is correct. In 6.2SP2 behaviour is the same (date minus one day). Also tried Pega 7.2.1 PE - it can't parse this format OOTB as well. Unfortunately I have no HotFix for this version to check.
Accepted Solution
PEG
IN
Similar kind of discussion going on regarding date is saving one day before. Please refer https://collaborate.pega.com/discussion/unable-pass-valuelist-summary-view-0