NOW Function

From Planfix
Revision as of 20:32, 25 December 2019 by SliZzzZ (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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:


5VqaFy.png


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).


Go To