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 |
||
| Line 9: | Line 9: | ||
''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: | ||
Revision as of 20:31, 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).