The min/max functions currently required numbers. Being able to use these (and other) functions for dates / intervals would simplify formulas.
To get the “most recent date” of a lookup I currently use min(date_diff('day', field('Dates'), today()))
where a min(field('Dates'))
returning a date-type in min
would make this easier for other formulas.
Hello @philipcristiano, first of all, welcome to the Baserow community
Thanks for sharing your idea, I’ll discuss it with the team
Hi @philipcristiano! I’m excited to share that your request has been accepted and we will allow the use of min/max functions for dates. I’ll be sure to keep you posted on the release of this feature, although we don’t have any specific estimates at this time