JULIAN DATE
Description
Converts a standard Gregorian formatted date to JDE's custom CYYDDD Julian-like date number.
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: 12/31/2016
- Quick Calculations > Date Julian Date
- Output: 116366