JULIAN TO DATE
Description
Will convert a JDE formatted Julian date format (CYYDDD) to a Gregorian Date format.
Parameters
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Date Literal | ✔ |
Remarks
The returned Julian date format includes leap years. This is JDE's own special Julian Date Format
Example
- Input: 116366
- Quick Calculations > Date > Julian to Date
- Output: 12/31/2016