NOW Function: Difference between revisions
From Planfix
(Created page with "The NOW function returns the current date in minutes. It's used to compare dates from different report fields or columns with the current time. ''Format:'' NOW() ''Exa...") |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
''Format:'' | ''Format:'' | ||
NOW() | '''*NOW()''' | ||
''Example:'' | ''Example:'' | ||
A report displays the number of days left until a task is done: | A report displays the number of days left until a task is done: | ||
| Line 15: | Line 16: | ||
Note: the difference between the task's planned completion date (column C) and the value returned by the NOW function is calculated in minutes. Therefore, if you want to display the result in days, divide the value you get by 1440 (the number on minutes in a day). | '''Note:''' the difference between the task's planned completion date (column C) and the value returned by the NOW function is calculated in minutes. Therefore, if you want to display the result in days, divide the value you get by 1440 (the number on minutes in a day). | ||
Latest revision as of 20:32, 25 December 2019
The NOW function returns the current date in minutes. It's used to compare dates from different report fields or columns with the current time.
Format:
*NOW()
Example:
A report displays the number of days left until a task is done:
Note: the difference between the task's planned completion date (column C) and the value returned by the NOW function is calculated in minutes. Therefore, if you want to display the result in days, divide the value you get by 1440 (the number on minutes in a day).