Date Functions

The DateFormulaLibrary class provides various date manipulation functions.

Functions

TODATE

• Description: Converts a string to a date.
• Parameters: 1 (String)
• Usage: TODATE(string)

FORMAT

• Description: Formats a date according to a specified format.
• Parameters: 2 (Date, String)
• Usage: FORMAT(date, format)

TODAY

• Description: Returns the current date.
• Parameters: None
• Usage: TODAY()

TIMESTAMP

• Description: Returns the current timestamp.
• Parameters: None
• Usage: TIMESTAMP()

NOW

• Description: Returns the current date and time.
• Parameters: None
• Usage: NOW()

YEAR

• Description: Returns the current year.
• Parameters: None
• Usage: YEAR()

MONTH

• Description: Returns the current month.
• Parameters: None
• Usage: MONTH()

DAY

• Description: Returns the current day.
• Parameters: None
• Usage: DAY()

DAYOFYEAR

• Description: Returns the current day of the year.
• Parameters: None
• Usage: DAYOFYEAR()

ADDDAYS

• Description: Adds a specified number of days to a date.
• Parameters: 2 (Date, Number)
• Usage: ADDDAYS(date, days)

ADDMONTHS

• Description: Adds a specified number of months to a date.
• Parameters: 2 (Date, Number)
• Usage: ADDMONTHS(date, months)

ADDYEARS

• Description: Adds a specified number of years to a date.
• Parameters: 2 (Date, Number)
• Usage: ADDYEARS(date, years)

DIFFINDAYS

• Description: Calculates the difference in days between two dates.
• Parameters: 2 (Date, Date)
• Usage: DIFFINDAYS(date1, date2)

DIFFINMONTHS

• Description: Calculates the difference in months between two dates.
• Parameters: 2 (Date, Date)
• Usage: DIFFINMONTHS(date1, date2)