I need to create a report based off of the [task] table that shows the # of days between the current date and task.due_date.
I've seen a lot of discussions around calculating durations that involve the current date. None of them seem to address this particular scenario -- scenario being the use of the current date in a date calculation.
What would you enter in the Script box (shown in the screenshot) to make this happen?
If a function field is the wrong way to get there, I'm open to suggestions 😀 thanks!
Found a solution!
Add a dictionary entry like this:
This function is calculating the # of days between today and sys_updated_on; it is displaying that calculation in a column named "Time Since Updated" in table "u_age_tasks."
Found a solution!
Add a dictionary entry like this:
This function is calculating the # of days between today and sys_updated_on; it is displaying that calculation in a column named "Time Since Updated" in table "u_age_tasks."
