Option 1: Use XL to give you the answer. Enter a in a XL worksheet.
Save the file in XML format. Check the XML file using a text editor.

Option 2: Recognize that XL stores dates as a whole number with 1 being
1/1/1900 and time as a fraction of a number with 0.0=midnight and 1.0
=next midnight.

Personally, I would go with 1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
please tell me the date type format which is supported by excel 2005.

i'm using xsd also for importing xml into excel and specified date type or
datetime type there in xsd but it is imoprting it as text.giving error this
error it is imorting as text.

the format which i specified is yyyy-MM-dd hh:mm:ss aaa in my jsp which is
throughing xml.