x = "12:24:13 03 Sep 1998" lcDate = ; SUBSTR(x,10,2) + "/" + ; TRANSFORM((ATC(SUBSTR(x,13,3),"JanFebMarAprMayJunJulAugSepOctNovDec") + 2) / 3) + "/" + ; SUBSTR(x, 17, 4) + " " + ; SUBSTR(x, 1, 8) ldDate = CTOT(m.lcDate)
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, 23 May 2014 1:48 AM To: [email protected] Subject: Re: Date String to Datetime On 2014-05-22 11:39, Ken Kixmoeller (ProFox) wrote: > Hey - -- > > Been *such* a long time for this kind of stuff. > > Any quick way to convert this string: > > "12:24:13 03 Sep 1998" > > To a datetime value? > > Currently, I am constructing one with substr() but I have a nagging > suspicion that there is an easier way (VFP9) Hi Ken, I'd use GetWordNum in a UDF (function) and build it yourself. Cheers, --Mike [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
