Product Feedback Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: New Idea

We would like to be able to use the Max() and Min() function on date so we can easily get the earliest or most recent date.

5 Comments

This seems like a pretty standard feature and would be a really nice addition.

 Hi,

Thanks for sharing your feedback and submitting this idea. This is vital for us.

We have this request in the backlog, but unfortunately, it is not prioritized for the short-term plans.  I will keep you updated on the progress.

Yes!

In both a row/pivot column, as well as a measure.

@Oleksandr_K Is there a work around you recommend until this feature becomes available?

One work around I am using is getting the minimum amount of days between now and the date I want to get the maximum of. Happy to hear of any others or if this formula could be turned back into a date somehow. The AddDays() function from the query build doesn't seem to be available in the widget functions.

MIN(DDiff(NOW(), [Days in date_field]))