CURDATE(), INTERVAL 1DAY) not working :(

[xwishmasterx]

I am using the below code for todays count and it works fine:

 

...AND left(vtp_tracking.action_date,10) = CURDATE()

 

I was hoping I could use the below code to select yesterdays count:

 

....AND left(vtp_tracking.action_date,10) = CURDATE(), INTERVAL 1 DAY)

 

but doesnt seem to work.

 

Is there anything I am missing (there must be)?

 

 

[Pikachu2000]

....AND left(vtp_tracking.action_date,10) = DATE_SUB( CURDATE(), INTERVAL 1 DAY) )

[xwishmasterx]

thanks for your reply Pikachu2000

 

your code didn't work, however It showed me what was wrong

 

The right code is:

 

....AND left(vtp_tracking.action_date,10) = DATE_SUB( CURDATE(), INTERVAL 1 DAY)

 

thanks