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

1. Input: 116366
2. Quick Calculations > Date > Julian to Date
3. Output: 12/31/2016