ON THIS PAGE:
Format
MakeDateTime(Year ,Month ,Day ,Hour ,Minute ,Second [,TimeZone])
Returns
Returns the specified date/time as Unix epoch time.
Inputs
Year: A 4-digit year (eg 2006).
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
Month: A value from 1 to 12 for January to December.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
Day: The day of the month from 1 to 31.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
Hour: A value from 0 to 23.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
Minute: A value from 0 to 59.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
Second: A value from 0 to 59.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer
TimeZone: The geographical or UTC offset time zone (e.g. "Australia/Perth" or "UTC+08:00"). If not supplied, it assumes the configured calendar time zone.
Behaviour: Optional
Dimension: SingleValue
Valid data types: String
Examples
Expression: MakeDateTime(2016,2,3,4,5,6,"Australia/Perth")
Result: 1454443506
Release History
- MakeDateTime() 4.6.5
- Changed all parameters except TimeZone to support MultiCollection values.
- MakeDateTime() 4.0
- Initial version