DateTime

Description of formula:
DATETIME function creates datetime from specified values. Function make possible to convert date or datetime UTC to datetime.

Syntax:
DATETIME(year,month,day,hour,minute,second,[milisecond])
or
DATETIME(date)
or
DATETIME(date,hour,minute,second,[milisecond])
or
DATETIME(UTC)

Parameters:

year(type:number)

The value of the year may contain from one to four digits. 

month(type:number)

Number ranging from 1 to 12, which is the month of the year (January to December).

day(type:Number)

Number ranging from 1 to 31, which means the day of the month.

hour(type:number)

Number ranging from 0 to 23, which means the hour of the day.

minute(type:number)

Number ranging from 0 to 59, which means the minute of the hour.

second(type:number)

Number ranging from 0 to 59, which means the second of the minute.

millisecond (type:number)

- optional

date(type:date)

If only parametr in formula is date, formula return time: 12AM

UTC(type:UTC)

Datetime UTC, you want to convert to datetime

Returned type:

DateTime

=datetime(2016,1,1,1,1,1)
=datetime(2016,1,1,1,1,1,1)
=datetime(section1.A1, section1.A2, section1.A3, section1.A4, section1.A5, section1.A6) =datetime(A3)
=datetime(date(2016,1,1))
=datetime(utc(now())