record style export problem

[kaliak]

Hi,

Crystal 8.5, sql server 7.0, windows xp

when exporting to record style format(column no spaces), one of our formula fields, a date, is being truncated in some records but not all.

here is the formula below:
mid({@CDateSVC},7,4)+mid({@CDateSVC},1,2)+mid({@CDateSVC},4,2) which should output -> 20060131 but some of the output for this field looks like this 0023/0/

@CDateSVC is a field from the database and is a date as follows: 01/31/2006

We have already applied sp3 for 8.5

Any suggestions would be appreciated. Thanks.

 

[kaliak]

I don't know if you can answer your own questions but we just installed this fix->

http://support.businessobjects.com/library/kbase/articles/c2014451.asp

It fixed both the character separated value and record style (columns no spaces) problems.

 

[Madawc]

If @CDateSVC is a date field, try ToText(@CDateSVC, "yyyyMMdd"). Much simpler than snipping out bits of a date.

If it isn't a data, try Cdate(@CDateSVC) to make it one. Display and see what you get.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10