office-winner

Examples that use the current date in their criteria Top of Form To include items that ... Use this criteria Query result Contain today's date Date() Returns items with a date of today. If today's date is 2/2/2012, you’ll see items where the date field is set to Feb 2, 2012. Contain yesterday's date Date()-1 Returns items with yesterday’s date. If today's date is 2/2/2012, you’ll see items for Feb 1, 2012. Contain tomorrow's date Date() + 1 Returns items with tomorrow’s date. If today's date is Feb 2, 2012, you’ll see items for Feb 3, 2012. Contain dates within the current week DatePart("ww", [SalesDate]) = DatePart("ww", Date()) and Year( [SalesDate]) = Year(Date()) Returns items with dates during the current week. A week in Access starts on Sunday and ends on Saturday...