Re: I'm being lazy - any already built DTOS() <--> STOD() function for a form?

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.

©2010 <kamcginnis@gmail.com>