Flashcards
Query Criteria which Involve Dates
Cards in this deck (9)
- 1#2/2/2012#Returns only items with a date of Feb 2, 2012.
- 2Not #2/2/2012#Returns items with a date other than Feb 2, 2012.
- 3< #2/2/2012#Returns items with a date before Feb 2, 2012.
- 4> #2/2/2012#Returns items with a date after Feb 2, 2012.
- 5>#2/2/2012# and <#2/4/2012#Returns items with a date between Feb 2, 2012 and Feb 4, 2012.
- 6Between #2/2/2012# and #2/4/2012#Returns items with a date between Feb 2, 2012 and Feb 4, 2012.
(OTHER WAY) - 7<#2/2/2012# or >#2/4/2012#Returns items with a date before Feb 2, 2012 or after Feb 4, 2012.
- 8#2/2/2012# or #2/3/2012#Returns items with a date of either Feb 2, 2012 or Feb 3, 2012.
- 9In (#2/1/2012#, #3/1/2012#, #4/1/2012#)Returns items with a date of Feb 1, 2012, March 1, 2012, or April 1, 2012.
Information
- Description
- This gives you the what you would enter and what would the result would be
- Created by
- Leann McLeod
- Views
- 4
- Rating