Calculating using current date (1 Viewer)

Hmm, I've been wondering and experimenting...
How does one list all activities within the last month (and the month would be the current month, whenever the current month is) from a table such as:

tblActivity
activityid
activityname
startdate
enddate

I tried using the TODAY () function in an SQL query and Access said there was an undefined function (TODAY() ) in the statement.

Date() is the function that returns today's date.

I use this in a query when I want to view data for the current month;
Between DateSerial(Year(Date()),Month(Date()),1) And Date()