Date & Time Custom Functions

These custom functions are primarily related to date and time values.

Days to Christmas

You can use this function to determine the number of days until Christmas.

Days until a Given Date

You can use this function to determine the number of days until a given date.

Days until Year End

You can use this function to determine the number of days until the end of the year.

There is a LAST_DAY( ) function for determining the last day of the month for a given date, but not one for the first day. This function returns the date for the first day of the month given.

Foreign Language Day Name

This function will return the name of the day of the week for a given date in a foreign language.

Last Quater

This function returns the quarter number (i.e., 1, 2, 3, or 4) for the previous quarter.