latest date

[Anonymous]

Good day!

How i can get latest date with added condition?

For this table i must get latest date, where the quantity > 2 (09.11.2013)

date	Quantity
12.11.2013	2
09.11.2013	3
08.11.2013	4
07.10.2013	6
06.10.2013	8

Thank you!

[Anonymous]

but my task is to get max date, where quantity > 2  !!!!!!!!!!!!!!!!

(09.11.2013)

[lironbaram]

hi

so you can use max({<quantity={">2"}>}Date)

or

max(aggr(if(sum(quantity)>2,Date),Date))

[vardhancse]

({$<Account>'2'>}'vMaxDate')

it will display max date for account>2

[Anonymous]

Hi

try this

Date(Max({<Quantity = {">2"}>} date),'DD/MM/YYYY')

you will get the O/P as 09/11/2013