Adding back Leading Zeros

P

Pete August

I have a query with the following field

trim(str(format( [Contracts].[EXP_DATE],"MMYY")))

When I use a TransfeText macro function to export the data - single digit
months lose there leading zero.

How do I structure for format statement to ouput January-2005 as 0105
 
R

Rosco

Pete
What are you exorting to?
If it is excel, than Excel is formatting as a general number format, which
will drop the leading zero.

Try exporting to a text file, and you should keep your formatting.

Rosco
 
Top