Max date <= today

[#1]

Hello

I'm trying to define a variable setting Max date lower than today.

Max date works with this formula

=max({<INFOCUBE={P_ORDR_3}>}  SID_0CALDAY.DATE0)

but I need to add "<= today"

SID_0CALDAY.DATE0 format is dd.mm.yyyy

thanks and regards

[#2]

Hi Tamil

thanks but it seems not to work...

If I put expression in a listbox I get '-'

[tamilarasu]

Hi Andrea,

Sorry for the late reply.. It was very hard to type in mobile.

Firstsortedvalue({<INFOCUBE={'P_ORDR_3'},SID_0CALDAY.DATE0={"<=$(=Date(today(),'DD.MM.YYYY'))"}>}SID_0CALDAY.DATE0,-SID_0CALDAY.DATE0)