Re: Forcing leading zeros

On Nov 19, 2008, at 11:28 AM, VanBuskirk, Patricia wrote:

> 1) How do you force a field to be exactly two digits, ie. 01, 02,  
> 03 ...
> 48?

Make it a text field, Right ( number & "0" ; 2 )

> 2) How do you force Get( CurrentDate ) to have leading zeros in the
> month/day?

For display? Use the Format|Date menu.

--
Don't sweat the petty stuff. And don't pet the sweaty stuff.
 Lorne Walton, Maple Ridge, BC, Canada 

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au