Discussion

1
Replies
581
Views
 Zuzana Greslikova (ZuzanaG8)
PwC

PwC
SK
ZuzanaG8 Member since 2015 1 post
PwC
Posted: October 15, 2015
Last activity: October 22, 2015
Posted: 15 Oct 2015 8:10 EDT
Last activity: 22 Oct 2015 10:41 EDT
Closed

Problems with sending xml message with element in dateTime format

How can I send an xml message which contains element which has got dateTime format ? 
I need to send value like this "2015-09-29T08:30:28.000+02:00"

In case that the property I'm sending has got Text format in Pega, I've got an error message when creating response: "String was not a datetime" (dateTime format according to xsd schema is correct) 

In case that the property I'm sending has got dateTime format I need to convert my value into dateTime. I tried it using function formatDateTime, and toDateTime but It does not work for my value. I could get through validation without any error but in my response I got just default dateTime value "1970-01-01T00:00:00.000Z" 

I would appreciate any help

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 5 years ago
Posted: 22 Oct 2015 10:41 EDT
Hans Bernving (Bernving)
Bernving Associated
Senior Instructor
Bernving Associated
NL

I think the correct format is 'yyyyMMddThhmmss.eee' were yyyy is year, MM is month, dd is day, hh is hour (24 hours format) mm is minute, ss is second and eee is millisecond, Zi stimezone difference from UTC. In your case please try '20150929T083028.000+0200' or maybe without the time zone (''20150929T063028.000")