I am trying to do a date calculation in a query that worked in access 97 but is not working in access 2007.
I want my query to return data for all transactions that occur in a certain date range relative to the current date. I am trying to collect this data in one week increments. For instance, I have a query titled 90days. I want this query to collect data for transactions that have a sale date range beginning 90 days prior to the current date and ending 96 days prior to the current date. In the old program I put the following expression in the criteria field for my sale date:
Between Date()-90 and Date()-96
With this expression in my query, I get the following error message when I try to run the query in access 2007:
"Undefined function 'Date' in expression."
I am certainly not a power user of this program, but I depend on these queries to do a weekly mail merge with my database, and I am at a loss to fix this error.
Thanks in advance for your time and help.