How to change date to text CR8.5?

[Digitalcandy]

I've tried;

ToText({table.datefield}, "M/dd/yy&quot

Visually the above looks ok but there is a space in day portion of the string. It converts like below;

actual date field = 2/5/04
after formula conversion = 2/ 5/04

What am I doing wrong?

 

[synapsevampire]

Try:

ToText({table.datefield}, "M/d/yy&quot

You can also just right click the date field and select format field and format the date however you'd like.

-k

 

[Digitalcandy02]

Sorry for the confusion but that is what I did. I didn't mean to write my code as M/dd/yy. I am actually using M/d/yy. However, it seems to create an empty space in day section when it is less than day 10.

For instance;

date field = 2/5/04
ToText date field = 2/ 5/04

I need it to be a text field because if the date meets a certain criteria the field will display the character " - ".

 

[synapsevampire]

Sounds odd, it shouldn't do that.

Try applying the latest service pack:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

Here's an alternative:

totext(month({table.datefield}),0,"&quot+"/"+totext(day({table.datefield}),0,"&quot+"/"+totext(year({table.datefield}),0,"&quot

-k