Last date before a certain date

[#1]

Hi everyone.

I'm trying to create a expression where I show the last date associated with a product before the date selected.

For example, I want to see the last date associated with a product before 2012-12-31.

If Product A has 2012-10-10,2012-01-01,2013-04-04 dates associated with it, then the last date before 2012-12-31 is 2012-10-10.

Can anybody help me?

[Clever_Anjos · Accepted solution]

=max({1<[yourDate]={"<$(=max([yourDate]))"}>}[yourDate])

[#3]

Thank you so much for your answer. This is almost what I need.

I need to select the last date prior a selected date. This selected date will be stored in a variable so my expression will be something like

=date(max({1<P_DATE={"<$(=V_DATE)"}>} P_DATE))

But I can't seem to make this expression work with a variable.

[Clever_Anjos]

What didn´t worked?

[#5]

Never mind, I just managed to make it work. My variable V_DATE wasn't in the correct Date Format before but now it's fixed. Thank you for your help!