Author: <kamcginnis@gmail.com>
Posted: 2010-06-16 at 13:17:00
Fred's is what we use: (I am pretty sure we got this on this list years ago.)
FUNCTION StoD
LPARAMETERS tcDateInDtoSFormat
SET CENTURY on
RETURN EVALUATE("+{^"+TRANSFORM(tcDateInDtoSFormat,"@R 9999/99/99")+"}")
----- Original Message -----
From: "Fred Taylor" <fbtaylor@gmail.com>
To: "ProFox Email List" <profox@leafe.com>
Sent: Wednesday, June 16, 2010 7:58 AM
Subject: Re: I'm being lazy - any already built DTOS() <--> STOD() function for a form?
?EVALUATE("+{^"+TRANSFORM("20100616","@R 9999/99/99")+"}")
Fred
On Wed, Jun 16, 2010 at 7:06 AM, Vincent Teachout <teachv@taconic.net>wrote:
> Stephen Russell wrote:
> >
> > I just had to play that game DTOS and STOD.
> >
> > Are you going to always get 8 digits in YYYY MM DD format? Or could
> > they be a real PITA and present
> > 2010111 and you have no idea if it is 1 Nov. or 11 Jan.
>
> Nope - always in YYYMMDD format - it's for the new Govt. CMS files for
> Medicare. Very strict layout.
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/0a8d01cb0d77$bc2d8440$7a00a8c0@w2k3s02
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.