Skip to main content

 

Planview Customer Success Center

DateTime Function

DateTime (year as Numeric, month as Numeric, day as Numeric, hour as Numeric, minute as Numeric, second as Numeric) as DateTime

Category: Date
Description: Creates a timestamp from a year, month, day, hour, min and second
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 return a year value
hour as Numeric Numeric value representing an hour (0-23), or reference to a field that will return an hour value
minute as Numeric Numeric value representing a minute (00-59), or reference to a field that will return a minute value
second as Numeric Numeric value representing a second (00-59), or reference to a field that will return a second value
Returned value as DateTime Returns a date time value using the specified "year", "month", "day", "hour", "minute", and "second" parameters
Example #1

Create a date time field representing May 1st 2011 19:30

DateTime(2011,5,1,19,30,00)

Example #2

Define a workflow rule that automatically sets a task's due date to be the end of the following day of the start date Choose the "Reschedule" action and set the start date to be the following:

DateTime(Year($StartDate),Month($StartDate),Day($StartDate)+1,16,00,00)

So that if a task's start date is January 2nd 2011, then the due date of that task will be January 3rd at 16:00

Tips
  • To update the standard date/date time fields, use workflow rules
  • Review other date and duration useful functions, such as DateAdd(), ToDate(), etc
Related Functions

DateAdd()

ToDate()