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 2008 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)

Look at an example (source file xml, report, and parameter file to execute report) at url: http://www.5websoft.com/sample.zip

Import the file in the design and will to verify that interpret incorrectly the fields of type date as datetime

not mapped currently for fields..

Help.....

Thanks!

Former Member replied

You could always reformat the field to only display the date portion:

Format Field > Date and Time tab; choose the date style you need here.

Or create a formula to extract just the date and use this field in your report:

date({table.field})

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