Date Functions
- CALENDAR_MONTH
Returns a number representing the calendar month of "date_expression". - CALENDAR_QUARTER
Returns a number representing the calendar quarter of "date_expression". - CALENDAR_YEAR
Returns a number representing the calendar year of "date_expression". - DAY_IN_MONTH
Returns a number representing the day in the month of "date_expression". - DAY_IN_WEEK
Returns a number representing the day of the week for "date_expression" 1 for Sunday, 7 for Saturday. - DAY_IN_YEAR
Returns a number representing the day in the year for "date_expression". - DAY_ONLY
Returns a date representing the day portion of "dateTime_expression". - FISCAL_MONTH
Returns a number representing the fiscal month of "date_expression". This differs from CALENDAR_MONTH() if your organization uses a fiscal year that does not match the Gregorian calendar. If your fiscal year starts in March, 1 for March 12 for February. - FISCAL_QUARTER
Returns a number representing the fiscal quarter of "date_expression". This differs from CALENDAR_QUARTER() if your organization uses a fiscal year that does not match the Gregorian calendar. If your fiscal year starts in July, 1 for July 15 and 4 for June 6 - FISCAL_YEAR
Returns a number representing the fiscal year of "date_expression". This differs from CALENDAR_YEAR() if your organization uses a fiscal year that does not match the Gregorian calendar. - HOUR_IN_DAY
Returns a number representing the hour in the day for "dateTime_expression". - WEEK_IN_MONTH
Returns a number representing the week in the month for "date_expression". The first week is from the first through the seventh day of the month - WEEK_IN_YEAR
Returns a number representing the calendar week of a "date_expression". The first week is from January 1 through January 7
Parent topic: Salesforce.com