Most recent date variable

[#1]

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    

[tresesco]

Try this:

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

[jagan]

Try like this

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

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

Regards,

Jagan.

[#4]

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

[tresesco · Accepted solution]

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

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

[#6]

great! works fine!

thanks