Month Function
Month (dateTime as DateTime) as Numeric
Category: | Date |
Description: | Returns the number of any given month, 1 (January) and 12 (December) |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
dateTime as DateTime | Represents a date value or a field that will return a date value |
Returned value as Numeric | Returns a numeric value representing the month number in the year of the date value given in the "dateTime" parameter |
Example #1 |
Create a custom field that will return the month in which a project is due Month($DueDate) |
Example #2 |
Create a custom picklist field that will define the quarters in which projects will be delivered If(In(Month($DueDate),1,2,3),"Q1",If(In(Month($DueDate),4,5,6),"Q2",If(In(Month($DueDate),7,8,9),"Q3","Q4"))) |
Tips |
|
Related Functions | |
Additional Links |