Thanks, but I did it already.
On Thu, May 22, 2014 at 3:31 PM, Darren <[email protected]> wrote: > 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/CAFyV=lmqkjvpp59s-jppsgff+minqisgdacgixo4kut4pz5...@mail.gmail.com ** 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.
