Skip to Content
0
Sep 24, 2008 at 10:53 AM

Crystal Report that reads from an XML file Datetime or Date

61 Views

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