Skip to Content

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 25, 2008 at 03:12 PM

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

    Add comment
    10|10000 characters needed characters exceeded