These people make NO accommodations! We have to accommodate their every
whim! I am thinking maybe I can do a GetAsText and use the Right on the
month and day part ... but not sure how to do that ...
GetAsText (Date ( Right ( "0" & Get( CurrentDate ); 2 ); Right ( "0" &
Get( CurrentDate ); Get( CurrentDate ))
??
-----Original Message-----
From:
fmpexperts-bounces@...
[mailto:
fmpexperts-bounces@...] On Behalf Of Lorne &
Joan Walton
Sent: Wednesday, November 19, 2008 2:42 PM
To:
fmpexperts@...
Subject: 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_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
