Date question

[Myron S.]

I'm trying to make a calculation field transpose a date into a text string with leading zeroes in front of single digit months and days. For example, I need the date 1/5/2006 to calculate to 010506 as text.

The day(date) and month(date) functions seem to strip out any leading zeroes.

Thanks in advance.

[LaRetta]

You might try:

Right ( "00" & Month ( theDate ) ; 2 ) &

Right ( "00" & Day ( theDate ) ; 2 ) &

Right ( Year ( theDate ) ; 2 )

[Myron S.]

That worked like a charm.

thank you so much.