Format changes when send data from Crystal Enterprise to Excel

[lana123]

Hi,people.
I work with Crystal 10 and Oracle 8.
I created CheckLine formula in Crystal:
"00000000" + Trim({Table.Field1})
ToText({@CheckDate})+ Table.Field2 + Space(30)

@CheckDate:date({Table.DocDate})
Table.DocDate type is DataTime that I customise like MMDDYY in Options.
I published this report in Crystal Enterprise but I cannot send CheckLine properly in Excel: I tried all kind of formats but I get two date delimiters (//) in date string (@CheckDate) part of the string.
How I can proper string, without date delimiters (//)?
I'll appreciate any answer.
Thanks in advance,
Lana

 

[paulmarr]

Hi Lana,

This is a Crystal Reports question - not a Crystal Enterprise Question - but you want to format the date while turning it to a string:

ToText({@CheckDate},"ddMMyyyy") will give you "20022006" and will omit the "//" delimiters.

Cheers
paulmarr