Skip to main content

 

Planview Customer Success Center

Day Function

Day (dateTime as DateTime) as Numeric

Category: Date
Description: Returns the day number of the month of a given date or date time value
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 day number in the month of the date value given in the "dateTime" parameter
Example #1

Define a validation rule that will prevent defining a due date for a work item on the 13th of every month :). Set the evaluation criteria to be:

Day($DueDate) = 13

Tips
  • This function can be useful for Date() and DateTime()
  • To update standard date/date time fields, use workflow rules
  • Review other date and duration useful functions, such as DateAdd(), ToDate(), etc
Related Functions

Date()

DateTime()