i run a logbook for pilots.
I'm trying to have a query that can come up with a date that is in the preceding 3 calander months.

Right now i have:

SELECT Sum(MAIN.DAY_LAND+MAIN.NIGHT_LAND) AS TOTALLAND FROM MAIN WHERE PER_ID='$username' AND MAIN.DATE >= date_sub(current_date, interval 3 month)

but this won't work for me. It needs to round up automatically.

so if the current date is 5/20/2004 it needs to check on dates from 1/31/2004

Is this possible?

thanks
Noam