Add DAYS interval to the Ago function

[amr_elwadiah]

Please add support to the Ago function to allow using DAYS intervals, as currently, it has Years, Quarters, and Months intervals only.

This will save writing a good amount of code to implement the required logic.

[JoeM]

Good idea @amr_elwadiah  - would using the function of daysbetween() (with one date being the current date) be a usable workaround for you?

[amr_elwadiah]

In fact no. Daysbetween() is beneficial though, I would be using it with ago() if it had Days interval, for example, "ago(some_date, daysbetween(date1, date2), "DAYS")".

The use case I was looking to implement, is that I have some flags "1"s, that I wanted to sum up between two dates, those flags denote weekends or holidays for example. So, having the ago function working on the days level would be better.