topic Most recent date variable in QlikView

Most recent date variable

Mon, 08 Jul 2013 11:45:39 GMT

Dear all,

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?

many thanks

Joris

tresB — Mon, 08 Jul 2013 12:10:10 GMT

Try this:

=FirstSortedValue(EffectiveDate, fabs(Today()-EffectiveDate))

jagan — Mon, 08 Jul 2013 12:23:38 GMT

Try like this

=Max({<DateFieldName={'<$(=Today()'}>} DateFieldName)

Make sure that date format is same in DateFieldName and Today().

Regards,

Jagan.

Mon, 08 Jul 2013 12:45:19 GMT

thanks,

this already works, but includes dates in the future too. what can i do to show the closest date in the past?

many thanks!

joris

tresB — Mon, 08 Jul 2013 12:55:16 GMT

so you don't need future dates comparison, try this :

=FirstSortedValue(EffectiveDate, (If((Today()-EffectiveDate)>0,(Today()-EffectiveDate))))

Mon, 08 Jul 2013 12:57:43 GMT

great! works fine!

thanks