DATEDIFF in WHERE clause

[pwills]

Newbie question; what is wrong with

SELECT COMPANY FROM COMPANIES
WHERE
DATEDIFF ('m',INVOICED_ON,GETDATE()) = 1

I want to list all COMPANIES invoiced any time last month

 

[osjohnm]

Hi

Try this:

SELECT COMPANY FROM COMPANIES
WHERE
DATEDIFF (m, INVOICED_ON, GETDATE()) = 1

There is no need to have the month in quotes 'm'.

John