Make Start and Due Dates, and Topic Properties in date format, available in formulas
Voting Open
At the moment Start and Due Dates cannot be directly incorporated into formulas. Similarly, any topic property formatted as a date or time field is simply not recognised by formulas. This is despite the fact that a number of task attributes related to Start and Due Dates such as Effort and Duration can be accessed.
The easiest way to fix this is to make Start and Due Dates available as a date number in formula Task Attributes similar to the way in which Excel can handle dates - and, ideally, using the same numbering system. A similar approach could be used to handle topic properties formatted as a date or time.
Another important aspect of this I forgot to mention would be to also provide TODAY as a date number which can be accessed in formulas. This would make it much easier to calculate the number of days from now until a task is due, or since it was started, etc. I know that the MAP add-in provides extended topic properties for Days to Task Start and Task Days Elapsed, etc, but TODAY should be available as numeric topic property, alongside Start Date and and Due Date.
Another important aspect of this I forgot to mention would be to also provide TODAY as a date number which can be accessed in formulas. This would make it much easier to calculate the number of days from now until a task is due, or since it was started, etc. I know that the MAP add-in provides extended topic properties for Days to Task Start and Task Days Elapsed, etc, but TODAY should be available as numeric topic property, alongside Start Date and and Due Date.
Commenting has been turned off on this page