Re: Forcing leading zeros

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

> 1) I may be looking at it wrong, but it seems that should be Right  
> ( "0" & number ; 2 )??
>
Is my face red?  ;-)

> 2) It would be for an export file ... the people we are sending the  
> file to need it to be, for example, "OTCWOCREATE_10192008_01.dat"  
> with the current date in the middle (2-digit mo, 2-digit day, 4-
> digit year)


Then they need to have the field (that they're importing into)  
formatted with leading zeroes. Unless you want to send them dates that  
are actually text. In which case, see 1).

--
I'm sorry, but I don't apologize for that.
Lorne Walton, Maple Ridge, BC, Canada

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