Hello everyone I try this: SELECT * FROM [BILLS] WHERE [CODCLIENTE] = 8 AND [Data] =(SELECT DateAdd(mm, -1, GetDate()) ORDER BY [Data]) but gives error. thx. ...