Defining Date Format in XSD Not Working!

[jasonp45]

I have an XML file which has dates in YYYYMMDD format.

I am trying to import this into Access 2003.

I have a valid XSD which will allow my data to import...however, I can only get the dates to come through as strings.

I am trying to insert dashes with a pattern:
<xs:element name="Exp_Date" type="dateType"/>
<xs:simpleType name="dateType">
<xs:restriction base="xs:string">
<xsattern value="[1,2][0-9]{3}-[0-9]{2}-[0-9]{2}"/>
</xs:restriction>
</xs:simpleType>

But it isn't working. How can I get my XSD to transform YYYYMMDD dates to valid XML dates so Access will import them properly?

Thanks!

 

[Juris]

Hi!
Restrictions are used to control acceptable values for XML elements or attributes - not for transformation!

Juri Shutenko
Municipality of Maardu, Estonia

http://kodu.neti.ee/~juri4

http://www.hot.ee/jurisfox