Hi,
I was wondering if anyone has encountered this problem before? I am exporting a crystal report file to excel and format of the date field TRADE_DATE is coming out strange. i.e:
| PARTY_ID |
TRADE_DATE |
END_DATE |
| CX |
() 16-Jul-2003 |
20-Sep-08 |
| CX |
29-Jul-2003 |
20-Sep-08 |
| CX |
09-Dec-2003 |
20-Dec-08 |
Some trade_date fields are automatically in Custom Type "dd-mmm-yyyy" format ( which is the correct format)
but some are in Custom Type "() dd-mmm-yyyy" format which is incorrect.
I am not sure why this happens.
Any help would be greatly appreciated.
IP Logged