E1 Time to DateTime
Description
Converts JD Edwards Date Updated and Time Updated columns into a single DateTime column.
Parameters
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Date Literal (Date Input) | ✔ |
| Input 2 | Column or Date Literal (6 Digit Number) | ✔ |
Remark
The JDE time format is an integer in the form of hhmmss.
Example
- Input: 12/31/2017 for Date Input and 230021 for Time Input
- Quick Calculations > JDE > E1 Time to DateTime
- Output: 12/31/2017 11:00:21 PM