ToText Function in crystal reports 1

[chevyimpala]

Hi,

I am using the ToText function in a query for my report. It takes the currentdate and complies it to be text, however it is removing the 0 in the single diget days of the week. So for example instead of looking like 5/04/2004 it reads 5/4/2004. My report needs the extra 0 in the date section in order to calculate my numbers. Can anyone help me figure out how to get it to keep the 0 for single digit days.

THX

Ivan

 

[vidru]

Try:

ToText(CurrentDate, "M/dd/yyyy")

-dave

 

[chevyimpala]

Dave you are the man, Thanks for the help.

Ivan