Your're welcome!
Albert
On 16/04/2013 4:06 PM, Karen Tellef wrote:
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> <http://www.avg.com>
> Version: 2013.0.3272 / Virus Database: 3162/6248 - Release Date: 04/16/13
>
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
