Date operators are used to extract date information from date fields when we want to calculate statistics based on the day of the week/month/year using the pipeline:
- $dayOfYear is used to get the day of the year within a range of 1 to 366 (for a leap year)
- $dayOfMonth is used to get the day of the month within a range of 1 to 31
- $dayOfWeek is used to get the day of the week within a range of 1 to 7, with 1 being Sunday and 7 being Saturday (using English days of the week)
- $isoDayOfWeek returns the weekday number in the ISO 8601 date format within a range of 1 to 7, with 1 being Monday and 7 being Sunday
- $week is the week number within a range of 0 to 53, with 0 being the partial week at the beginning of each year ...