Skip to main content
Planview Customer Success Center

DateValue Function

DateValue (expression as String, format as String) as Date

Category: Date
Description: Returns a date value from a string given in the following format: YYYY-MM-DD
Supported Context: FormulaField And BusinessRules
Parameters:  
expression as String Represents a text value as a string, or reference to a field that will return a string value given in the following format: YYYY-MM-DD
format as String  
Returned value as Date Returns a date value using the text specified in the "expression" parameter
Example #1

Create a custom field that will return a set Date Value, or one based off of another custom or standard field

DateValue(“2011-05-01”)