Date Subtraction in Access2007 Query, then show >30 and <60 days
Posted on 2011-02-15
I work in a law firm and trying to develop a MS 2007 Access query that will help us determine how long a case has been opened. The main table has a column called "Date Opened". Part One: In my query, I have selected "Date Opened" and then wrote the Expression of "Expr1: DateDiff("d",[Date Opened],[Now]). When I run the query, I have to manually enter today's date, the 'Now'. Doesn't Access already know today's date and can it run without asking me? Part Two: How can I get the query to only return case open dates of greater than 30 but less than 60 (but not equal to) days? Thank you.