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
Date Format
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]":@VM:"MCN")Code: Select all
DIGITS(Oconv(Iconv(InputLink,"D2/","D YMD[4,2,2]"))IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Or...
Code: Select all
Convert(" ","",Oconv(Iconv(InputLink,"D2/"),"D YMD[4,2,2]"))-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers