Projection Functions
CONVERTCURRENCY(column)
Returns the currency field converted to the user's currency
- column: Any column expression.
CALENDAR_MONTH(column)
Returns a number representing the calendar month of a date field (1 for January, 12 for December).
- column: Any column expression.
CALENDAR_QUARTER(column)
Returns a number representing the calendar quarter of a date field (1 for January 1 through March 31, 2 for April 1 through June 30, 3 for July 1 through September 30, 4 for October 1 through December 31).
- column: Any column expression.
CALENDAR_YEAR(column)
Returns a number representing the calendar year of a date field (2009).
- column: Any column expression.
DAY_IN_MONTH(column)
Returns a number representing the day in the month of a date field (20 for February 20).
- column: Any column expression.
DAY_IN_WEEK(column)
Returns a number representing the day of the week for a date field (1 for Sunday, 7 for Saturday).
- column: Any column expression.
DAY_IN_YEAR(column)
Returns a date representing the day portion of a dateTime field (32 for February 1).
- column: Any column expression.
DAY_ONLY(column)
Returns a date representing the day portion of a dateTime field (2009-09-22 for September 22, 2009).
- column: Any column expression.
FISCAL_MONTH(column)
Returns a number representing the fiscal month of a date field. 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.
- column: Any column expression.
FISCAL_QUARTER(column)
Returns a number representing the fiscal quarter of a date field. 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, 4 for June 6.
- column: Any column expression.
FISCAL_YEAR(column)
Returns a number representing the fiscal year of a date field. This differs from CALENDAR_YEAR() if your organization uses a fiscal year that does not match the Gregorian calendar (2009).
- column: Any column expression.
HOUR_IN_DAY(column)
Returns a number representing the hour in the day for a dateTime field (18 for a time of 18:23:10).
- column: Any column expression.
WEEK_IN_MONTH(column)
Returns a number representing the week in the month for a date field (2 for April 10). The first week is from the first through the seventh day of the month.
- column: Any column expression.
WEEK_IN_YEAR(column)
Returns a number representing the week in the year for a date field (1 for January 3). The first week is from January 1 through January 7.
- column: Any column expression.