Hey, that works! Sorta! I did the SRPL on my text column, and also used it to change the 2-digit year to a full 4-digit year. Then I changed the date to DD-MM-YYYY. I attempted to set a date column equal to this column and got an "expression does not return a valid date". However, I can cursor thru the column, set an empty vDate DATE variable and pull it in just fine. Stick that into the Date column, change my format back to MM-DD-YY and we're good to go.
Thanks! Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Apr 16, 2013 4:56 pm Subject: [RBASE-L] - Re: Converting a mm-ddd-yy date How about convert the MMM to MM? UPDATE xxx SET Datecol = (SRPL(DateCol,"JAN","01",0)) and so on. Albert On 16/04/2013 3:39 PM, Karen Tellef wrote: > I'm trying to convert a TEXT column into something recognizable as a > date. The text column has words such as: > 08-Feb-10 > > I tried doing > SET DATE DD-MMM-YY > > My #Date displays properly. But this results in "your value does not > have the sametype..." error: > SET DATE DD-MMM-YY > SET VAR vDate DATE = NULL > SET VAR vDate = .vText > > I suppose I can monkey around with pulling the individual pieces and > doing an RDate but I was hoping for something easier.... > > Karen > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2013.0.3272 / Virus Database: 3162/6248 - Release Date: 04/16/13 >
