Can anybody help me with a function where I can generate the date in this format?
20080729
I have not find any option to get this using oconv iconv.
Please help
Date Format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
DIGITS(Oconv(Iconv(....),"DYMD[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.
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
@DATE is already in internal format - so you don't need Iconv().
To pre-empt Craig, "that's certainly one variation".
Code: Select all
Oconv(@DATE, "DYMD[4,2,2]":@VM:"MCN")
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.