How to display dates from a Dataset.

[AGIMA]

I am connecting to a Dataset that has been exported using the XMLDataDocument.

However when I display the dates in the report it display the entire contents of the field and does not reconise it as a date field.

There also does not seem to be any properties in Crystal reports to tell it that it is in fact a date field.

What it display is 2004-11-07T00:00:00.0000000+11:00 Where I want it to only display 7/11/2004 (being in Australia).

I am using Crystal.net and also tried to fix the problem using v10, but still no luck. I dont really want to do any reformatting to get around this problem, so if anyone knows of a way to do it directly in Crystal it would be much appreciated.



AGIMA - professional web hosting is our business.

AGIMA Computing

http://www.agima.com.au

 

[dtempleton]

Try using a formula in its place:

DateValue (tonumber(left({XMLTABLE.DATEFIELD}, 4)), tonumber(mid({XMLTABLE.DATEFIELD}, 9,2)), tonumber(mid({XMLTABLE.DATEFIELD}, 6,2)))