Date Format Issue with Crystal Export with Excel Data Only

building reports crystal reports
1

Hello Experts,

I am facing a strange issue with Crystal Report.
I have a date time column which is timestamp type (ORACLE DB).
I have defined proper format as ‘dd/MM/yyyy HH:mm’ (24 Hour format) in Format Filed->Custom Style.
When I export this report in Excel Data format, the date column looks proper but when I checked with Format Cell in excel it shows me format as ‘dd/MM/yyyy" "hh:mm’.
I tried different ways to resolve this. I need same format which I put in CR. Due to this format our other dependent tools are not working.

Any comprehensive input required to resolve this issue.

vijesh.chandra :india: (BOB member since 2009-05-29)

2

I cannot say for sure (I do not export to Excel very much). But formatting a date in CR does not change the underlying data. Put the field in a formula and see if you can convert the date to the correct format.

kevlray :us: (BOB member since 2010-06-23)

3

Hi,
I tried that too but it also didnt help.me. Again getting the same result. Is it possible for you to suggest what and how to do formatting using formulas.

vijesh.chandra :india: (BOB member since 2009-05-29)

4

Look at the totext function. Probably something like this, totext({timedatefield},“dd/MM/yyyy HH:mm”)

kevlray :us: (BOB member since 2010-06-23)