Module datetime 

Date and time functions (Phase 3) Functions implemented: TODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEVALUE, TIMEVALUE, EDATE, EOMONTH

Structs

DateFn

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

DateValueFn

DATEVALUE(date_text) - Converts a date string to serial number

DayFn

DAY(serial_number) - Extracts day from date

EdateFn

EDATE(start_date, months) - Returns date that is months away from start_date

EomonthFn

EOMONTH(start_date, months) - Returns last day of month that is months away

HourFn

HOUR(serial_number) - Extracts hour from time

MinuteFn

MINUTE(serial_number) - Extracts minute from time

MonthFn

MONTH(serial_number) - Extracts month from date

NowFn

NOW() - Returns current date and time as serial number (volatile)

SecondFn

SECOND(serial_number) - Extracts second from time

TimeFn

TIME(hour, minute, second) - Creates a time serial number (fraction of day)

TimeValueFn

TIMEVALUE(time_text) - Converts a time string to serial number fraction

TodayFn

TODAY() - Returns current date as serial number (volatile)

YearFn

YEAR(serial_number) - Extracts year from date

Functions

create_date_normalized

Create a date from year, month, day with Excel normalization Excel normalizes out-of-range values (e.g., month 13 becomes next January)

date_to_serial

Convert date to Excel serial number Handles the 1900 leap year bug

date_to_serial_for

Convert a date to Excel serial according to the provided date system.

datetime_to_serial

Convert datetime to Excel serial number

datetime_to_serial_for

Convert a datetime to Excel serial according to the provided date system.

register_builtins

serial_to_date

Convert Excel serial number to date Handles the 1900 leap year bug where Excel incorrectly treats 1900 as a leap year

serial_to_datetime

Convert Excel serial number to datetime The fractional part represents time of day

serial_to_datetime_for

Convert a serial to datetime according to the provided date system.

time_to_fraction

Convert time to fractional day (0.0 to 0.999…)