Last date with data formula required

[#1]

Hi,

I want to create a variable which is the date at which a particular product ends.

For example if the sale of Product XYZ ended in Dec 2012 while the financial year ends in April 2013, what function could I use?

thanks in advance

C

[Gysbert_Wassenaar]

Try: max({1<Product={'XYZ'}>} MyDate)

[#3]

Thanks Gysbert.

This is kind of what I need however, the month Jan to April have zero's in them therefore the mas date being picked up is still April 2013 not Dec 2012.

I know I need to use set analysis in some way but not sure of the syntax.

=max({sum of the data is <> 0} Date)

[Gysbert_Wassenaar]

max({1<Product={'XYZ'},SalesAmount-= {0}>} MyDate). The -= is correct even though the expression editor flags it as wrong with a red line. Change SalesAmount with the name of the field that has the 0 values.