I have a Crystal Report that reads from an XML file, the source File XML Date data looks like this: 2008-03-10
But the Crystal Report interpreted by datatime, I need the Crystal Report to look like this: 2008/03/10 (date) not 2008-03-10T00:00:00-05:00 (datatime)
Help.....
Schema xs
http://www.w3.org/2001/XMLSchema"
....
<xs:element name="dt_usercreate" type="xs:date" minOccurs="0" />
Source XML
<dt_usercreate>2008-09-23</dt_usercreate>
In Crystal
dt_usercreate 2008-09-23T00:00:00+01:00 like the datatype Datatime not Date