i would like to set a variable defining the date closest to today. in my files i also have dates in the future, so max(date) won't work.
i am looking in the direction of minizing the delta between today() and the date field. can anyone help?
this already works, but includes dates in the future too. what can i do to show the closest date in the past?
so you don't need future dates comparison, try this :
great! works fine!
Try like this
Make sure that date format is same in DateFieldName and Today().
Retrieving data ...