Penultimate date sales in dynamic table

[cafcptg2011]

Hi,

PROBLEM: Is to display last date of sales in a given period in dynamic tab. i have attached a qvw file to show better my problem.

thanks in advance,

cafc

[#2]

is this what you need?

=aggr( min(total {< sales_date = {'>=$(=date('01-03-2010')) <$(=date('03-03-2011'))'}, val={">0"}>} sales_date),val)

[cafcptg2011]

thank you for your answer, but indeed is not what i need. I need simply the max (date) in a given period of time, you see?

thanks

cafc

[#4]

-

[cafcptg2011]

yes, but with your expression will given wrong dates for others customers, you see? so i took your expression and i adapted to this :

=aggr( max( {< sales_date = {">=$(=date('01-03-2010')) <$(=date('03-03-2011'))"}, val={">0"}>} sales_date),id_customer)

and its seem to be working now.

so, thank you very much.

cafc

[#6]

hadn't seen your reply, kept working on it and this works too

=max({< sales_date = {'>=$(=date('01-03-2010')) <$(=date('03-03-2011'))'},val={">0"}>} sales_date)