Hi,
I ahve rewuirement like this
how to convert 26-FEB-10 into 26/02/2010
So can anyone suggest me how to do this in parallel job.
Thanks in advance.
how to convert 26-FEB-10 into 26/02/2010
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
Code: Select all
x=26-FEB-10
svMon=UPCASE(Field(x,"-",2))
If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' ...
You are the creator of your destiny - Swami Vivekananda
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
Thanks for your replyanbu wrote:Code: Select all
x=26-FEB-10 svMon=UPCASE(Field(x,"-",2)) If svMon = 'JAN' Then '01' Else If svMon = 'FEB' Then '02' ...
i will try it and let you know.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use StringToDate() to convert to binary date format, and DateToString() to convert back to desired format. Use appropriate date format strings for each function.
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.
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am