Re: perid_diff problem

[Felix Geerinckx]

jahar wrote:

> SELECT ID
> FROM Purchases
> WHERE PERIOD_DIFF( DATE_FORMAT( (
> NOW( ) , "%y%m" ) ) , DATE_FORMAT( (
> PurchaseDate
> ), "%y%m" )
> ) =24
> LIMIT 0 , 30

Too many parentheses, try:

SELECT ID FROM Purchases
WHERE
PERIOD_DIFF(DATE_FORMAT(NOW() , "%y%m") , DATE_FORMAT(PurchaseDate, "%y%m" ))=24
LIMIT 0 , 30;

--
felix
Please use BBCode to format your messages in this forum.