I believe there is a bug with the latest rollup function to grab the most recent date in the relation.
It probably has something to do with the dd/mm/yyyy vs mm/dd/yyyy format.
My sheet uses the dd/mm/yyyy format.
Because it’s a more logical format
When there are two flippable dates (dates that can be interpreted as mm/dd or dd/yy depending on where you live) using the dd/mm/yyyy format =
06/01/2018 (6th Jan 2018) vs 01/06/2018 (1st June 2018), it will pick up 06/01/2018 instead as the latest.
I’m not sure what I should be looking for in your app. Sheet2 only shows the fruit name. Understandably, it’s probably a bug, but your safest bet would be to store dates or display them in yyyy/mm/dd. It might be different in the builder vs the published url too, so that’s something to check.
Maybe try adding a column in your sheet to act as a helper column, format the dates in Glide’s format. Use that as the column to Rollup.
If you’re having an issue with formatting the dates, a more complex workaround would be to use a DATEVALUE formula in that column. You’d then use this column to configure the maximum value for your Rollup column!
The ONLY caveat to this solution is if you’re looking for instant calculations/comparisons with dates for filtering/visibility purposes. The 5-10 second lag might be a deal breaker. Such was the case with my Meet with Me app. Meet with Me: A Booking App that Prevents Conflicts
