help me to show data on column1 where condition on column2 is date?
col1_int        col2_date
100              8/2/2009
210              8/1/2009
160              8/5/2009
125              8/8/2009

I want show my data in col1_int where condition on col2_date is maximum date and else minimum date?

i was try this code:
IF {table.col2_date}=Minimum ({table.col2_date}) THEN
col1_int

but if i create same code use maximal then one of that be a zero value.

thaks all


Edited by sem.live - 14 Jul 2010 at 12:25am