« Return to Thread: Forcing leading zeros

Re: Forcing leading zeros

by Steve Hearn :: Rate this Message:

Yes, you can do the auto-enter calc and have it replace existing data.

To format your dates for that export you'll need to put it together:

Right ( "00" & Month ( dateField ) ; 2 ) & Right ( "00" & Day ( dateField )
; 2 ) & Year ( dateField )

By habit, I add as many zeroes as digits I'm capturing in case the value I'm
padding is empty. In this case that won't happen unless the entire date
field is empty.

------------------------------------------------
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: "VanBuskirk, Patricia" <pvanbuskirk@...>
> Reply-To: <fmpexperts@...>
> Date: Wed, 19 Nov 2008 14:40:10 -0500
> To: <fmpexperts@...>
> Conversation: Forcing leading zeros
> Subject: RE: Forcing leading zeros
>
> Can I do an auto-enter calc on the field using Right ( "0" & SELF ; 2) ?
>
> -----Original Message-----
> From: fmpexperts-bounces@...
> [mailto:fmpexperts-bounces@...] On Behalf Of Steve
> Hearn
> Sent: Wednesday, November 19, 2008 2:36 PM
> To: FileMaker Experts
> Subject: Re: Forcing leading zeros
>
> 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
> _______________________________________________
> FMPexperts mailing list
> FMPexperts@...
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

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

« Return to Thread: Forcing leading zeros