How to make filter on most recent date

Hey Jetreport

how do i make a filter that will show the value for the latest (oldest) date, without filter on exact date 21-04-2022, but the highest date?

i have 3 sales prices

first 9,75 (startdate 01-07-2014 enddate 01-07-2015)

second 9,35 (startdate 02-07-2015 enddate 23-03-2020

third 7,65 (Startdate 05-05-2021 enddate 21-04-2022)



Please sign in to leave a comment.