curdate() minus int query

[hotliquer]

Hi,
I have a problem when using this query:
select * from arcade_takings where date = curdate() – 2;

If i change the int at the end to "1" it works fine. like this:
select * from arcade_takings where date = curdate() – 1;
Anything over "2" it returns nothing at all even though data exists for 31st March

It seems to have a problem going backwards from April to March

Any ideas guys would be of great help to me!

Thanks

Ben

 

[TonyGroves]

Use:
[tt]
CURDATE - INTERVAL 2 DAY
[/tt]

 

[hotliquer]

Thanks tony!