XML Date Field

  • 25 January 2016
  • 0 replies
  • 4 views

Userlevel 5
Badge +18


 

Symptoms


I'm loading a table of data into XML using a SmartObject Event with a list method outputting to an XML dataset that I created. One of the fields is a date field (in SQL and in the SmartObject. If my XML field is set to date I receive an error when the process runs. If I change it to a string field then I get a value of the date and 12:00:00 AM which is not desired.

Error Message:
SmartObject Event xml validation against schema failed: The 'expiry' element is invalid - The value '12/31/2015 12:00:00 AM' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:date' - The string '12/31/2015 12:00:00 AM' is not a valid Date value.
 

Diagnoses


This issue that we are experiencing was logged as as bug.
 

Resolution

Unfortunately, there is not a current timeline as to when this bug will be addressed. The workaround is as you had described, to perhaps use an 'xs:string' xml field to store this value for the time-being.




 

0 replies

Be the first to reply!

Reply