When using durations it’s very nice to be able to measure the time between two dates.
For example, imagine I am supposed to finish a task by Thursday and today is Monday, this would give me 3 days to finish the task. If instead I was supposed to finish by this Monday and today is Thursday, I’m late, I should have finished 3 days ago.
So far, Coda works perfectly for this task:
ToDate(Today() + 3) - Today()) =>
ToDate(Today() - 3) - Today()) =>
3 days ago
Now, imagine that I finished the task 3 days late, and that I want to keep track of the fact that I was late finishing the task (perhaps I’m trying to improve my forecasting ability by looking at past tasks). So, I create a table that looks something like this:
Notice how confusing that is, the “Timeliness” column says that I finished
3 days ago, which is not true at all. I finished 3 days past the deadline.
Were Coda to change this text to instead say
3 days past it would make sense in this context, unlike
3 days ago. Furthermore, “past” preserves its meaning in other contexts as well:
I’m late, I should have finished 3 days past.
ToDate(Today() - 3) - Today())=>
3 days past