Hi,
I need to convert a Date input column having format YYYY-MM-DD to output as YYYYMMDD. I tried Oconv(Iconv(DSLink3.date1,"D-YMD"),"DYMD") but the output is coming as YYYY MM DD. How can I achieve my original desired results? I searched through the DS Help but couldnt find a solution for this.
Thanks,
Date format conversion: YYYY-MM-DD to YYYYMMDD
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Sat Jul 08, 2006 4:09 am
- Location: Melbourne, Australia
- Contact:
Date format conversion: YYYY-MM-DD to YYYYMMDD
Durga Prasad
or you can use the following code
OR
Code: Select all
Oconv(Iconv(InLink.Date, "DYMD[4,2,2]"), "DYMD[4,2,2]":@VM:"MCN")
Code: Select all
DIGITS(InLink.Date)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.