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
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
  • To update standard date/date time fields, use workflow rules
  • Review other date and duration useful functions, such as DateAdd(), ToDate(), etc
Related Functions

DateAdd()

ToDate()

Additional Links

custom picklist field