Happy Snowy Friday from WI, list.
I would like to extract part of a text column and insert into a date column.
The data looks like: 4/9/2008 confirmed
So I've tried:
UPDATE MyTableTemp SET +
StockArriveDateD = (SSUB(StockArriveDateT,-1)))
(StockArriveDateD is a date col, StockArriveDateT is a text 30 col)
That gets the first word of the text column, 4/9/2008.
But, the "Expression does not return a valid date"
I tried adding DEXTRACT, but apparently DEXTRACT can't be fooled into
converting text, it wants a DATETIME datatype.
So, how do I convert a date-looking text into a valid date? I looked
through the functions and tried several, but to no avail.
In the Christmas spirit, check this video for some fascinating vocals:
http://www.youtube.com/watch?v=2Fe11OlMiz8
Doug
