Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home

Symptoms

When generating an XSD (XML Schema Definition) file through DIXF, for an entity that contains a DateTime field, the schema is incompatible with the XML file that is exported from DIXF. If you attempt to validate the XML file against the XSD file, you will get errors like:
The 'DateTimeField' element is invalid - The value '2006-02-01 00:00:00' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:dateTime' - The string '2006-02-01 00:00:00' is not a valid DateTime value.

↑ Back to the top

Resolution

Change the validation in the XSD file for DateTime fields. Instead of requiring the format to be 'yyyy-MM-ddTHH:mm:ss', the required format is now 'yyyy-MM-dd HH:mm:ss'. This format is compatible with the format that DIXF exports XML files in.

↑ Back to the top

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top

Article Info
Article ID : 4032505
Revision : 1
Created on : 6/14/2017
Published on : 6/14/2017
Exists online : False
Views : 164