Day in Week, Month, Quarter or Year Functions

Use the following functions to find the position of a day within a week, month, quarter, or year.

Date position functions take this syntax.

  • Day of Week

    Returns an integer that represents the day of the week for a specific date.

  • Day of Month

    Returns an integer that represents the day of the month for a specific date.

  • Day of Quarter

    Returns an integer that represents the day of the quarter for a specific date. The first quarter of the year begins on January 1.

  • Day of Year

    Returns an integer that represents the day of the year for a specific date.