Currently, when adding a date field as a value in a pivot table, the only option is the # of years/# of days/etc. We need the option to add a minimum and/or maximum date for the selected rows. The c...
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.
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]))