I'm doing a database that records jobs to be completed.
I want to be able to see what jobs are due for this month, what jobs are due next month and what jobs are due two months from now (seperate query for each of these). I need it to work forever and thus can't use set dates.
How would I go about doing this, I know I should use 'now' somewhere in the filter term but I don't know the rest!
Please help!