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
