Selecting the field pertaining with the max date field

[udana]

Dear all,
I need to find a field value(field1) which pertain to the latest date(field2)....
all these fields are in the same table...
the data stream is given bellow.... the maximum date's value should be taken as the result

field2                field1
01/10/2008   30,081.12
01/10/2008   18,048.67
01/10/2008   120,324.48
01/11/2008   0
01/11/2008   50.14
1/14/2008   421,135.68
1/16/2008   60,162.24
1/16/2008   30,081.12
1/17/2008   60,162.24


thanks in advance

[almeids]

Won't the filter [field2]=maximum([field2]) do it?