Get the Last previous date value

[#1]

Dear All,

            I need a solution for this query,

utput  : If I select the date 10-sep-2011 then I should get the value for  07-sep-2011(200)

Regards,

Ravi.

[jagan]

Hi,

Try this, hope this helps you.

= Date(Max({<DateField={'<$(=Date(Max(DateField)))'}>} DateField))

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     try with this expression,

          =FirstSortedValue({<Date={"<$(=Date)"}>} Value,-Date)

     It works perfectly if the date is selected.

Hope it helps

Celambarasan