Date Error

[adams06]

Hi

i am getting date in this format 82205

if i use this code

OCONV(ICONV(FMT(Link.DATE,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]")

i am getting the following error:
data for column exceeds column width (8), row 33 (approx), data = 2005/08/22

My Target column length is 8 and sql type is varchar.

can any one suggest me.

Thanks in advance.

[DSguru2B]

Dont you already have an open thread???

[aditya]

Try trimming the year field as YY instead of YYYY.

Play around with the options of ICONV.

HTH
Aditya.

[ray.wurlod]

The delimiter characters ("/") are making this date 10 characters long, so it won't fit in a Char(8) field. Change the second argument of Oconv() to

Code: Select all

"DYMD[4,2,2]":@VM:"MCN"