Date functionality in Formula Builder

[senordhuff]

We have users requesting to create Formulas by selecting dates.

For example,

Today - Updated Date = 6 days

The easiest way to do this would be to display dates in the Source Field list in Formula Builder and have the date be converted to milliseconds for use in formulas. Are there any plans to allow anything like that? Or, do we need to roll our own for that? It would definitely require a power-user comfortable with javascript date handling but seems feasible if the fields were to just show up in the list and the value was treated like a millisecond.

[Isomorphic]

To make this a coherent feature for the product, we wouldn't want to just make the date available as epoch time, which only a true programmer would understand. Instead, we'd provide a small library of MathFunctions that make sense for dates (like extracting day of week, day of year, etc) and document all that, make it i18n-compatible, etc.

That could be sponsored, but just dumping the value as epoch time would be more something where you could roll your own.