DateTime to Numeric
Description
The DATETIME TO NUMERIC will take a date with an optional JDE time added to it and format it to several numeric formats.
Parameters
Options
| Input | Input Values |
|---|---|
| Output Format | Excel Numeric Date, HHmmss, Hours, Minutes, Seconds, yyyyMMddHHmmss |
| Date | Column or Date Literal |
| JDE Time | Column or Date Literal |
| Only Rollup If | Column or Date Literal |
Remarks
Format of the 'Excel Numeric Date'. From Excel doc : Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900
JDE Time format. Its format is HHmmss. Note that is used often in JDE ERP tables.
Example
- Input:
- Date: 06/01/2017
- Time: 152705
- Design > Calculations > DateTime to Numeric
- Output Format: yyyyMMddHHmmss
- Fill in Date and Time as seen above
- Output: 20170601152705