Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
so you don't need future dates comparison, try this :
Try like this
Make sure that date format is same in DateFieldName and Today().
this already works, but includes dates in the future too. what can i do to show the closest date in the past?
great! works fine!