How do I put a date range in a query

Lady Jane · July 19, 2004

New to SQL I am doing something wrong in my SQL query to pull the data from last week. I have used the form

WHERE dbo.UserEvent.DateModified > (now()-7)

changing the date indicator "now" to date, today, currdate and playing with the brackets in different forms makes no difference. Mostly I get

[Microsoft] [ODBC SQL Server Driver] [sql Server] 'now' is not a recognised function name.(-1)

changing the bracket type can change the message. This request is an exact copy of one suggested earlier on this list, where have I gone wrong?

slstrother · July 20, 2004

This link may be of some help.

Recommended Posts