Skip to main content
Planview Customer Success Center

DateTimeValue Function

DateTimeValue (text as String, format as String) as DateTime

Category: Date
Description: Returns a timestamp value from a text given in the following format: YYYY-MM-DD hh:mm:ss
Supported Context: FormulaField And BusinessRules
Parameters:  
text 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 hh:mm:ss
format as String  
Returned value as DateTime Returns a date time value using the text specified in the "text" parameter
Example #1

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

DateTimeValue(“2011-05-01 19:30:00”)