Show all records from current and previous month 1

[likelylad]

Hi
I was hoping someone could help me.
I would like to run a query that will show me all the records from the current month and the previous month. Account will also have to be taken of the end of the end as in January 2003 I will need to look at the figures in December 2002.

The format is like

select * from mytable where ??????????

The field where the dates are held is called logindate and it is in date/time format.

Thanking in advance for any help received

 

[sleipnir214]

Try:

WHERE logindate > concat(year(date_sub(now(),interval 1 month)),'-',month(date_sub(now(),interval 1 month)),'-01') ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!