Page 1 of 1

date conversion

Posted: Mon Dec 19, 2005 6:30 pm
by rklebanov
I have a string like this "2004.SEP.15"
Need to transform into string "20050915"

Prompt response is appreciated. I am new with iconv, oconv.

Thanks, KK

Posted: Mon Dec 19, 2005 8:56 pm
by kcbland
CHANGE(OCONV(ICONV(yourdate, "D"), "D-YMD[4,2,2]"),"-", "")