« Return to Thread: Forcing leading zeros

Re: Forcing leading zeros

by Steve Hearn :: Rate this Message:

Reply to Author | View in Thread

Almost. Try Right ( "0" & number ; 2 )


------------------------------------------------
Steve Hearn
:: FileMaker 9 Certified Developer ::
FileMaker Technologies Team Leader
CoreSolutions Development Inc.
Web Site: http://www.coresolutions.ca
London: (519) 641-7727 - Toronto: (416) 410-8649
------------------------------------------------
software that works for you


> From: Lorne & Joan Walton <walton@...>
> Reply-To: <fmpexperts@...>
> Date: Wed, 19 Nov 2008 11:31:34 -0800
> To: <fmpexperts@...>
> Subject: Re: Forcing leading zeros
>
> Make it a text field, Right ( number & "0" ; 2 )

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

 « Return to Thread: Forcing leading zeros