Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference NUMBERTODATE
Functions and Expressions Reference Guide
155
NUMBERTODATE
The NUMBERTODATE function converts an integer to a date, where the integer is
the number of days from December 31, 1864, to the specified date.
Syntax
NUMBERTODATE (single-integer-expression)
Meaning
NUMBERTODATE (integer_to_convert)
Returns
This function returns a single-date.
This function converts an integer to a date. If the result is being assigned to a
date object, the resulting date is in the presentation for that output. If the
resulting date is not being assigned to an object, it has a CCYYMMDD
presentation.
Examples
NUMBERTODATE (StartDate)
This example converts the StartDate from an integer to a date that is in
CCYYMMDD format.
Uses
Use
NUMBERTODATE to perform a calculation on a date.
Related Functions
ADDDAYS, DATETONUMBER, FROMDATETIME, TODATETIME