DSXchange

Hi All,

I am getting a strange issue with Iconv Oconv function. I have generated a function to retrive a date and insert it in the target table.

The function i have written is as follows :
" OCONV(ICONV("Column_Name","D-MDY"),"D YMD[4,2,2]") "

It is working fine for some dates and they are geting inserted properly in the target but for some dates it is sending blank. On further analyzing this issue deeper i found out that dates having day > 15 for e.g. 15th Sep 2008 is going as blank but a date like 2nd SEP 2008 is going fine as is in the target .
Not able to conclude why this is happening. any pointers on this issue are welcomed. Thanks in Advance

please let us know the input format of date, give an example of your input date.

My date format is "19-SEP-08" in source table.

OCONV(ICONV(ereplace("19-SEP-08","-"," "),"D2"),"D YMD[4,2,2]"), so when your input is "19-SEP-08" output is 2008 09 19, taking your oconv format into account.

The IConv mask must match the incoming date format. You've used "ICONV("Column_Name","D-MDY")" and shown a date example of "19-SEP-08". See the problem?

Thanks Craig it working now. I used as follows:

OCONV(ICONV(ColumnName,"D DMY"),"D YMD[4,2,2]")