SQL filter passed 30 days.

Hi Everybody

I'm attempting to generate a report from a GRID which will automatically (by opening the form willclick a button, starting the sql)  list all clients that are passed 30 days.

Here is what i managed to develop, but it still doesn't work.

     SELECT     Sipad,Namecombined,date30days   
     From          ClientDbf         
     WHERE     DATE(date30days) > DATE(('now', '-30 days');   

Any tips ?

Also I did manage to attempt something that didn't work, and ended up getting the date columb in the grid with hours 00:00:00  is there something in the SQL script i must do to truncate it to only the date ?

Tks.

jeff