<< 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. >>
UPDATE MyTableTemp SET StockArrivalDateT = (SRPL(StockArrivalDateT, '/', ',', 0)) UPDATE MyTableTemp SET StockArrivalDateD = + (RDATE(INT(SSUB(StockArrivalDateT, 1)), INT(SSUB(StockArrivalDateT, 2)), INT(SSUB(StockArrivalDateT, 3))) This is two commands instead of one. If you want to make it only a single command, replace every occurence of StockArrivalDateT in the second UPDATE with (SRPL(StockArrivalDateT, '/', ',', 0)) and you'll be good to go. -- Larry
