Hi guys!!!
I've designed a report containing a column with data type DATE cutomized as YYYYMMDD without "/" (only digits), It works in Crystal perfectly, when there is any date to show, and when there is no, shows blank, but when I export to Excell in DATA ONLY mode, the column with DATE data type, for many lines show me 19000100 instead "blank" when there is no date to show (Data = zero) in the Excell spreadsheet.
I'll appreciate if somebody can help me.
Thanks in advance!!!
GonFer
I've designed a report containing a column with data type DATE cutomized as YYYYMMDD without "/" (only digits), It works in Crystal perfectly, when there is any date to show, and when there is no, shows blank, but when I export to Excell in DATA ONLY mode, the column with DATE data type, for many lines show me 19000100 instead "blank" when there is no date to show (Data = zero) in the Excell spreadsheet.
I'll appreciate if somebody can help me.
Thanks in advance!!!
GonFer