View previous topic :: View next topic |
Author |
Message |
nk.nithya Beginner
Joined: 28 Dec 2007 Posts: 4 Topics: 2 Location: India
|
Posted: Thu Jul 02, 2009 9:27 am Post subject: convert date format ddmmyy to ddmmccyy |
|
|
I am having a requirement that I want to add century to the date coming from the input in the format DDMMYY.Please tell me how to add century to date format DDMMYY to get DDMMCCYY. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Thu Jul 02, 2009 10:49 am Post subject: |
|
|
nk.nithya,
Use the DATE-TO-YYYYMMDD function and convert the date to a 4 digit year. Since your input has YY at the end , you need to move to temp variable as YYnnnn and invoke the function
Check this link which explains in detail about the function
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3LR10/7.1.11
Kolusu |
|
Back to top |
|
|
nk.nithya Beginner
Joined: 28 Dec 2007 Posts: 4 Topics: 2 Location: India
|
Posted: Sun Jul 05, 2009 9:22 am Post subject: |
|
|
Thanks for ur reply |
|
Back to top |
|
|
|
|