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 |
|
Related Functions |