DSXchange

Posted: **Tue Jul 29, 2008 10:56 pm**

Hi All,

I am trying to convert Date format from MM/DD/YY to YYYMMDD

I am using the function

Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]), but I am getting Space between.Like YYYY MM DD.

Can someone Please help me

Thanks
yar

Posted: **Tue Jul 29, 2008 11:22 pm**

Code: Select all

Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]":@VM:"MCN")

or

Code: Select all

DIGITS(Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]"))

Posted: **Tue Jul 29, 2008 11:42 pm**

Or...

Code: Select all

Convert(" ","",Oconv(Iconv(InputLink,"D2/"),"D YMD[4,2,2]"))

DSXchange

Date Format

Date Format