You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

The function returns a NUMBER date-time literal value obtained from a set of numeric values representing a date-time timestamp.

Syntax
dateTime(number year, number month, number dayOfMonth, number hourOfDay, number minute, timeZone time_zone) #Output: Number
Additional information

Parameters used in this function

ParameterInput (data type)Description
timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

The function returns a NUMBER