ADDMINUTES Function: Difference between revisions
From Planfix
m (Aliona moved page ADD MINUTES Function to ADDMINUTES Function without leaving a redirect) |
No edit summary |
||
| Line 6: | Line 6: | ||
}} | }} | ||
'''ADDMINUTES()''' — the function adds or subtracts a specified number of minutes from the selected date. | '''ADDMINUTES()''' — the function adds or subtracts a specified number of minutes from the selected date. | ||
== Format == | == Format == | ||
'''ADDMINUTES'''(Date, Count) | '''ADDMINUTES'''(Date, Count) | ||
== Examples == | == Examples == | ||
Add +50 minutes to today's date (24-06-2022 10:07): | Add +50 minutes to today's date (24-06-2022 10:07): | ||
'''ADDMINUTES'''(Now();50) — Result: 24-06-2022 10:57 | '''ADDMINUTES'''(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): | ||
Latest revision as of 12:56, 4 December 2024
ADDMINUTES() — the function adds or subtracts a specified number of minutes from the selected date.
Format
ADDMINUTES(Date, Count)
Examples
Add +50 minutes to today's date (24-06-2022 10:07):
ADDMINUTES(Now();50) — Result: 24-06-2022 10:57
Subtract -30 minutes from today's date (24-06-2022 10:20):
ADDMINUTES((Now();-30) — Result: 24-06-2022 09:50