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