ADDMINUTES Function: Difference between revisions
From Planfix
No edit summary |
|||
| Line 14: | Line 14: | ||
'''ADD MINUTES'''(Now();50) — Result: 24-06-2022 10:57 | '''ADD MINUTES'''(Now();50) — Result: 24-06-2022 10:57 | ||
Subtract -30 minutes from today's date (24-06-2022 10:20): | Subtract -30 minutes from today's date (24-06-2022 10:20): | ||
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