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

1. Input:
   • Date: 06/01/2017
   • Time: 152705
2. Design > Calculations > DateTime to Numeric
   • Output Format: yyyyMMddHHmmss
   • Fill in Date and Time as seen above
3. Output: 20170601152705