Hi

I want make one select . i have this table :

Name          date
John          01/01/2005
Peter         08/01/2005
John          15/01/2005
James         22/01/2005
Peter         31/01/2005
Bill          02/05/2005


I want select result is :

Name          date
John          15/01/2005
James         22/01/2005
Peter         31/01/2005
Bill          02/05/2005

that means that i only want the date for each person more next today .

Thanks