Ditto. 2 0's for the inevitable "empty". I have clients with dates
containing year only or year-month. To allow for proper sort
(alphabetically), the "date" has to be: YYYYMMDD. Pad the day and
month and take the right 2 digits. :)
--
Beverly Voth
mailto:
[hidden email]
tel:(606) 864-0041
--
On Nov 19, 2008, at 6:13 PM, Darren Terry <
[hidden email]>
wrote:
>
> On Nov 19, 2008, at 3:01 PM, Eric Scheid wrote:
>
>>> Right ( "0" & number ; 2 )
>>
>> Am I the only one that habitually writes this as
>>
>> Right ( "00" & number ; 2 )
>>
>> (and no, not because 'number' might be empty)
>
> No, I always use 2 zeros also -- but only because number can be empty.
>
> regards,
> Darren
>
> ******************************
> Darren Terry
[hidden email]
> Pacific Data Management, Inc.
http://www.pdm-inc.com/> 111 W. St. John St. Phone: (408) 283-5900 x303
> Suite 404 Fax: (408) 283-5903
> San Jose, CA 95113
> ***** FileMaker 9 Certified Developer *****
>
>
>
> _______________________________________________
> FMPexperts mailing list
>
[hidden email]
>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
