Make Start and Due Dates, and Topic Properties in date format, available in formulas

Alex Gooding shared this idea 22 days ago
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.

Comments (1)

photo
2

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.

Leave a Comment
 
Attach a file