Crystal Report that reads from an XML file Datetime or Date

[Former Member]

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!

[fritzfeltus · Accepted solution]

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

[former_member1133844]

Thank You,for this success advice...