ADDMINUTES Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
'''ADD MINUTES'''((Now();-30) — Result: 24-06-2022 09:50 | '''ADD MINUTES'''((Now();-30) — Result: 24-06-2022 09:50 | ||
== Go To == | == Go To == | ||
Revision as of 10:15, 28 February 2024
ADD MINUTES() — the function adds or subtracts a specified number of minutes from the selected date.
Format
ADD MINUTES(Date, Count)
Examples
Add +50 minutes to today's date (24-06-2022 10:07):
ADD MINUTES(Now();50) — Result: 24-06-2022 10:57
Subtract -30 minutes from today's date (24-06-2022 10:20):
ADD MINUTES((Now();-30) — Result: 24-06-2022 09:50