On 06/28/2012 04:32 PM, Dan Covill wrote: > On 06/28/12 15:51, MB Software Solutions, LLC wrote: >> I was going to import as a character(8) then do a translate via text >> manipulation into the DATE(YYYY,MM,DD) function, but wondered if >> someone's got a better idea? > Slightly better, perhaps: > ... import field to cDate ... > dDate = CtoD(left(cDate,2) + '/' + substr(cDate,3,2) ; > + '/' + substr(cDate,5,4)) > > Dan Covill > San Diego
I just did this today due to compiling VFP9 with Strictdate set to the default. I created a procedure named _ctod() which takes a string date as a parameter and returns date(yyyy, mm, dd). Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com _______________________________________________ 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.
