I just noticed there's an extra "+" in there. You shouldn't need the first
"+".
RETURN EVALUATE("{^"+TRANSFORM(tcDateInDtoSFormat,"@R 9999/99/99")+"}")
That's what I get for doing it off the top of my head. <g>
Fred
On Wed, Jun 16, 2010 at 10:17 AM, <[email protected]> wrote:
> 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" <[email protected]>
> To: "ProFox Email List" <[email protected]>
> 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 <[email protected]
> >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: [email protected]
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/[email protected]
** 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.
