Module date_time 

Date/time formula functions: DATE, TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEDIF, EDATE, EOMONTH, DATEVALUE, WEEKDAY, WEEKNUM, NETWORKDAYS, WORKDAY.

Functions

fn_date

DATE(year, month, day) - constructs a date serial number.

fn_datedif

DATEDIF(start_date, end_date, unit) - difference between two dates.

fn_datevalue

DATEVALUE(date_text) - converts a date string to a serial number.

fn_day

DAY(serial_number) - extracts the day from a date serial.

fn_edate

EDATE(start_date, months) - date that is N months before/after start_date.

fn_eomonth

EOMONTH(start_date, months) - last day of the month N months away.

fn_hour

HOUR(serial_number) - extracts the hour from a datetime serial.

fn_minute

MINUTE(serial_number) - extracts the minute from a datetime serial.

fn_month

MONTH(serial_number) - extracts the month from a date serial.

fn_networkdays

NETWORKDAYS(start_date, end_date, [holidays]) - working days between two dates.

fn_now

NOW() - returns current date and time serial number.

fn_second

SECOND(serial_number) - extracts the second from a datetime serial.

fn_today

TODAY() - returns today’s date serial number.

fn_weekday

WEEKDAY(serial_number, [return_type]) - day of the week.

fn_weeknum

WEEKNUM(serial_number, [return_type]) - week number of the year.

fn_workday

WORKDAY(start_date, days, [holidays]) - date after N working days.

fn_year

YEAR(serial_number) - extracts the year from a date serial.