Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report that reads from an XML file Datetime or Date

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

<xs:schema id="BD" xmlns="" xmlns: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

Not what you were looking for? View more on this topic or Ask a question