Skip to main content
Planview Customer Success Center

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
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


Example #2

Create a custom picklist field that will define the quarters in which projects will be delivered


  • To update standard date/date time fields, use workflow rules
  • Review other date and duration useful functions, such as DateAdd(), ToDate(), etc
Related Functions



Additional Links

custom picklist field