In a formula-type column, the DATEMINUTE_ADD() function displays a date and time obtained by adding a number of minutes to a date and time type column.
-
Function name:
DATEMINUTE_ADD()
Syntax
DATEMINUTE_ADD(date_column, number_of_minutes)
Calling function parameters in TimeTonic:
- $field_name = field (link, related table column, number, selection, formula, text...).
- "free text" = free text to add within quotes.
- do not use quotes for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date and time type column to which minutes will be added. |
number_of_minutes |
The integer number of minutes to add. Positive to move forward, negative to move backward. |
Example
DATEMINUTE_ADD($Date, 30)
The column returns the date and time shifted by 30 minutes.
Notes
- The source column must include the time.
- The number of minutes can be negative.
Return Type
The function returns a date and time.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output Format Options in the Formula Column article.
Business Use Case
DATEMINUTE_ADD() calculates a precise deadline: end time of an appointment of known duration, alert at T+15 minutes.
Best Practice
For a shift expressed in hours, use DATEHOUR_ADD().