DBohner-(db)
Legendary Poster
Howdy,
In the HR History table, the Date Terminated is stored as a string, in the F08042.JWHSTD column.
Basically, instead of being store as a date, it is stored in the same format as it would appear - if you looked at the value from the database:
109222
111021
...
BUT - the values are stored as STRING, not DATE and have to be converted....
I need to take that database formatted string, and convert it to a JDE Date - and I'm just not on enough medication (or I'm not finding the right keywords or I'm just lazy)...
Does someone have a simple means to convert a string-based Julian date to JDE Date?
The sun is out, I have a window, it's Friday - and I don't want to play computer geek anymore...
(db)
In the HR History table, the Date Terminated is stored as a string, in the F08042.JWHSTD column.
Basically, instead of being store as a date, it is stored in the same format as it would appear - if you looked at the value from the database:
109222
111021
...
BUT - the values are stored as STRING, not DATE and have to be converted....
I need to take that database formatted string, and convert it to a JDE Date - and I'm just not on enough medication (or I'm not finding the right keywords or I'm just lazy)...
Does someone have a simple means to convert a string-based Julian date to JDE Date?
The sun is out, I have a window, it's Friday - and I don't want to play computer geek anymore...
(db)