G
Gary F Shelton
My IT group has a date table. At first I didn't understand why we need the
table but now after I pulled some data out of our AS400 mainframe I
understand.
The data I pulled is Ship DT Centruy, Ship DT year, Ship DT month, Ship DT
Day... The format looks like this for a few records:
1 5 4 2 (The answer is 4/2/2005)
Now in the date table the record that ties back to 4/2/2005 is 1050402.
My questions are:
What math equation do I do to make sure that all records that have a Year of
one digit will have a zero in front of them?
What math equation do I do to make sure that all records that have a month
of one digit will have a zero in front of them?
What math equation do I do to make sure that all records that have a Day of
one digit will have a zero in front of them?
Such a pain ....
table but now after I pulled some data out of our AS400 mainframe I
understand.
The data I pulled is Ship DT Centruy, Ship DT year, Ship DT month, Ship DT
Day... The format looks like this for a few records:
1 5 4 2 (The answer is 4/2/2005)
Now in the date table the record that ties back to 4/2/2005 is 1050402.
My questions are:
What math equation do I do to make sure that all records that have a Year of
one digit will have a zero in front of them?
What math equation do I do to make sure that all records that have a month
of one digit will have a zero in front of them?
What math equation do I do to make sure that all records that have a Day of
one digit will have a zero in front of them?
Such a pain ....