var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: calander months (date query)
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?