Skip to main content

 

Planview Customer Success Center

Date Function

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