ADDMINUTES Function: Difference between revisions
From Planfix
No edit summary |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{#seo: | {{#seo: | ||
|title= | |title=ADDMINUTES Function | ||
|titlemode=append | |titlemode=append | ||
|keywords=planfix, reports, functions | |keywords=planfix, reports, functions | ||
|description=ADD MINUTES Function | |description=ADD MINUTES Function | ||
}} | }} | ||
''' | '''ADDMINUTES()''' — the function adds or subtracts a specified number of minutes from the selected date. | ||
== Format == | == Format == | ||
''' | '''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 | ||
Subtract -30 minutes from today's date (24-06-2022 10:20): | Subtract -30 minutes from today's date (24-06-2022 10:20): | ||
''' | '''ADDMINUTES'''((Now();-30) — Result: 24-06-2022 09:50 | ||
== Go To == | == Go To == | ||
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