Re: Reverse DTOS?

2009-08-26 Thread Mark Stanton
Thanks both, So quick when you know how :-) Regards Mark ___ 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

Re: Reverse DTOS?

2009-08-25 Thread Fred Taylor
Here's one that doesn't require VFP9: ?EVALUATE("{^"+TRANSFORM(DTOS(DATE()),"@R /99/99")+"}") Fred On Tue, Aug 25, 2009 at 7:03 AM, Dave Thayer wrote: > On Mon, Aug 24, 2009 at 3:53 AM, Mark Stanton > wrote: > > Is there really no VFP function that is the reverse of DTOS? > > > > DTOS tur

Re: Reverse DTOS?

2009-08-25 Thread Dave Thayer
On Mon, Aug 24, 2009 at 3:53 AM, Mark Stanton wrote: > Is there really no VFP function that is the reverse of DTOS? > > DTOS turns into "MMDD". I can break it apart manually and > put it back together as a date, but it's a bit laborious.  Nothing > already inside? > If you're using VFP9 here'

Re: Reverse DTOS?

2009-08-24 Thread Mark Stanton
Thanks Jeff, Now you mention it I seem to remember the client has this in their arsenal too. Probably far poorer than that though. TVM Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox O

Re: Reverse DTOS?

2009-08-24 Thread Ken Kixmoeller/fh
On Aug 24, 2009, at 8:27 AM, Jeff Johnson wrote: > I added this to my arsenal years ago: > > PROCEDURE stod I wrote the exact-same function -- even the name. I guess the name was obvious to folks steeped in Fox back in the day... Ken ___ Post Mess

Re: Reverse DTOS?

2009-08-24 Thread Jeff Johnson
I added this to my arsenal years ago: PROCEDURE stod LPARAMETER tcDateString IF TYPE('tcDateString') # 'C' RETURN {//} ENDIF IF VAL(tcDateString) = 0 RETURN {//} ELSE RETURN (DATE(VAL(LEFT(tcDateString,4)),; VAL(SUBSTR(tcDateString,5,2)),; VAL(SUBSTR(tcDateString

Re: Reverse DTOS?

2009-08-24 Thread Paul Hill
On Mon, Aug 24, 2009 at 10:53 AM, Mark Stanton wrote: > Is there really no VFP function that is the reverse of DTOS? > > DTOS turns into "MMDD". I can break it apart manually and > put it back together as a date, but it's a bit laborious.  Nothing > already inside? I've always wondered that m

Reverse DTOS?

2009-08-24 Thread Mark Stanton
Is there really no VFP function that is the reverse of DTOS? DTOS turns into "MMDD". I can break it apart manually and put it back together as a date, but it's a bit laborious. Nothing already inside? Mark Stanton One small step for mankind... _