Skip to Content
0
Former Member
Nov 12, 2012 at 10:43 AM

Date issue in crystal

67 Views

Hi,

I have a date column in the crystal report which contains values like 1/1/1800. In crystal report i can view this record(1/1/1800) but when i am exporting it to Excel, instead of getting 1/1/1800 i am getting #####. other dates are greater than 1900 and they are coming fine when i am exporting it to excel i have written the query in Add Command. The database i am using is DB2 and Crystal report version is XI.

can anybody help me on this?

Thanks

Syed Faiz