Guest User

Untitled

a guest
Aug 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. Exporting XML from Excel and Keeping Date Format
  2. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  3. <dataroot>
  4. <Tabelle11>
  5. <Title_1>2009-10-12T00:00:00.000</Title_1>
  6. <Title_2>40098</Title_2>
  7. </Tabelle11>
  8. <Tabelle11>
  9. <Title_1>2000-01-01T00:00:00.000</Title_1>
  10. <Title_2>36526</Title_2>
  11. </Tabelle11>
  12. </dataroot>
  13.  
  14. <xsd:element name="Title_1" minOccurs="0" od:jetType="datetime" od:sqlSType="datetime" type="xsd:dateTime">
  15. <xsd:annotation>
  16. <xsd:appinfo>
  17. <od:fieldProperty name="Format" type="10" value="dd.mm.yyyy"/>
  18. </xsd:appinfo>
  19. </xsd:annotation>
  20. </xsd:element>
  21. <xsd:element name="Title_2" minOccurs="0" od:jetType="text" od:sqlSType="nvarchar">
  22. <xsd:annotation>
  23. <xsd:appinfo>
  24. <od:fieldProperty name="Format" type="10" value="@"/>
  25. </xsd:appinfo>
  26. </xsd:annotation>
  27. <xsd:simpleType>
  28. <xsd:restriction base="xsd:string">
  29. <xsd:maxLength value="255"/>
  30. </xsd:restriction>
  31. </xsd:simpleType>
  32. </xsd:element>
Add Comment
Please, Sign In to add comment