;

Skip to main content

 

  • arrow icon
Language Selector

  1. Other Languages

    (machine translation)

 

Planview Customer Success Center

Date Function

  1. Last updated
  2. Save as PDF

Date (year as Numeric, month as Numeric, day as Numeric) as DateTime

Category: Date
Description: Creates a date from year, month and day values entered
Supported Context: FormulaField And BusinessRules
Parameters:  
year as Numeric Numeric value representing a year, or reference to a field that will return a year value
month as Numeric Numeric value representing a month (1-12), or reference to a field that will return a month value
day as Numeric Numeric value representing a day (1-31), or reference to a field that will retun a day value
Returned value as DateTime Returns a date value using the specified "Year", "Month", and "Day" parameters
Example #1

Create a date Custom Field that will automatically set the corporate fiscal year of the objects created date (e.g. May 1st). Set the formula to be:

Date(Year($CreatedOn),5,1)
Tips
  • To update standard date/date time fields, use workflow rules
  • Review other useful date and duration functions such as DateAdd(), ToDate(), etc.
Related Functions

DateAdd()

ToDate()

DateSubtract()
Additional Links

checkbox custom field