date

Use the date function to create a DateTime value with Integer values.

Function format

date(Integer year,
Integer month,
Integer day,
Integer hour,
Integer minute,
Integer second)

• year: value used for the year in the DateTime value.
• month: value used for the month in the DateTime value.
• day: value used for the day in the DateTime value.
• hour (optional): value used for the hour in the DateTime value.
• minute (optional): value used for the minute in the DateTime value.
• second (optional): value used for the second in the DateTime value.

date example

date(2018, 8, 1)

This formula returns the DateTime value 01 Aug 2018.