« Return to Thread: Forcing leading zeros

Re: Forcing leading zeros

by Ibrahim Bittar Torres :: Rate this Message:

Reply to Author | View in Thread

Hi Trish

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

Right ( "00" & Number , 2 )

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

Select the field and use Date Format in the Format menu.

Saludos

Ibrahim Bittar Torres
Director General
Eikonsys
FileMaker 9 Certified Developer
http://www.eikonsys.com
FileMaker Business Alliance

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

 « Return to Thread: Forcing leading zeros