View previous topic :: View next topic
|
Author |
Message |
ajaychandraredd1
New User
Joined: 06 Jun 2008 Posts: 8 Location: Minnieapolis
|
|
|
|
How do i convert the follwoing date value into regular MMDDYY Format in the fileaid.
EFF-DT S9(9) 80109898 |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
What date in mmddyy format is it suppose to be and what is the 9th digit. |
|
Back to top |
|
|
ajaychandraredd1
New User
Joined: 06 Jun 2008 Posts: 8 Location: Minnieapolis
|
|
|
|
I am not sure about the 9th digit |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You did not post what mmddyy date results from 80109898. . .
That is not a "date value" we are familiar with and needs explanation. How does 80109898 "convert" to mmddyy (or any other date presentation)? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Is this a 9's complement date? If so, first subtract the value from 99999999 and the resulting value can be manipulated as YYYYMMDD. |
|
Back to top |
|
|
ajaychandraredd1
New User
Joined: 06 Jun 2008 Posts: 8 Location: Minnieapolis
|
|
|
|
Hi Robert,
The answer was correct.... Thank You very much.
Ajay. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Robert,
Good catch
d |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Thanks Dick ... we've got a system that uses 9's complement dates that are VSAM key components; the 9's complement keeps them from all inserting at the end of the file. |
|
Back to top |
|
|
|