Tag Archives: Date & Time

The YEAR Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the year of a date, represented by a serial number. The year is given as an integer ranging from 1900 to 9999.

The MONTH Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the month of a date, represented by a serial number. The month is given as an integer ranging from 1 to 12.

The DAY Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.

The NOW Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the serial number of the current date and time.

The DATE Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It combines three separate values to form a date and returns that date.