Query function with date filter

	A	B	C	D	E	G	H	J	K	M	N	P	Q
1	Query Function with date filter		Ben Collins		benlcollins.com
2	Read more at:	http://www.benlcollins.com/spreadsheets/query-dates/
3
4	Feel free to make your own copy so you have editing rights.
5	File > Make a copy...
6
7	Question:	Get list of Shuttle missions after 1 January 2000 (from the Data tab)				1/1/2000		1/1/2000	12/31/2002
8
9	Example with INCORRECT date filter			Example with CORRECT date filter syntax		Example with CORRECT date filter syntax referencing date in separate cell (yellow)		Example with CORRECT date filter between two dates		Get all missions in month of January, regardless of year*		Get all missions on 1 July, regardless of year*
10										* the month() scalar function inside of query is 0-based, hence why I needed to add 1 to get January		* the month() scalar function inside of query is 0-based, hence why I needed to add 1 to get January
11	Mission	Launch Date		Mission	Launch Date	Mission	Launch Date	Mission	Launch Date	Mission	Launch Date	Mission	Launch Date
12				STS-99	11 February 2000	STS-99	11 February 2000	STS-99	11 February 2000	STS-51-C	24 January 1985	STS-94	1 July 1997
13	Where is the data?? Query is empty because date filter is incorrect			STS-101	19 May 2000	STS-101	19 May 2000	STS-101	19 May 2000	STS-61-C	12 January 1986
14				STS-106	8 September 2000	STS-106	8 September 2000	STS-106	8 September 2000	STS-51-L	28 January 1986
15				STS-92	11 October 2000	STS-92	11 October 2000	STS-92	11 October 2000	STS-32	9 January 1990
16				STS-97	30 November 2000	STS-97	30 November 2000	STS-97	30 November 2000	STS-42	22 January 1992
17				STS-98	7 February 2001	STS-98	7 February 2001	STS-98	7 February 2001	STS-54	13 January 1993
18				STS-102	8 March 2001	STS-102	8 March 2001	STS-102	8 March 2001	STS-72	11 January 1996
19				STS-100	19 April 2001	STS-100	19 April 2001	STS-100	19 April 2001	STS-81	12 January 1997
20				STS-104	12 July 2001	STS-104	12 July 2001	STS-104	12 July 2001	STS-89	22 January 1998
21				STS-105	10 August 2001	STS-105	10 August 2001	STS-105	10 August 2001	STS-107	16 January 2003
22				STS-108	5 December 2001	STS-108	5 December 2001	STS-108	5 December 2001
23				STS-109	1 March 2002	STS-109	1 March 2002	STS-109	1 March 2002
24				STS-110	8 April 2002	STS-110	8 April 2002	STS-110	8 April 2002
25				STS-111	5 June 2002	STS-111	5 June 2002	STS-111	5 June 2002
26				STS-112	7 October 2002	STS-112	7 October 2002	STS-112	7 October 2002
27				STS-113	23 November 2002	STS-113	23 November 2002	STS-113	23 November 2002
28				STS-107	16 January 2003	STS-107	16 January 2003
29				STS-114	26 July 2005	STS-114	26 July 2005
30				STS-121	4 July 2006	STS-121	4 July 2006
31				STS-115	9 September 2006	STS-115	9 September 2006
32				STS-116	9 December 2006	STS-116	9 December 2006
33				STS-117	8 June 2007	STS-117	8 June 2007
34				STS-118	8 August 2007	STS-118	8 August 2007
35				STS-120	23 October 2007	STS-120	23 October 2007
36				STS-122	7 February 2008	STS-122	7 February 2008
37				STS-123	11 March 2008	STS-123	11 March 2008
38				STS-124	31 May 2008	STS-124	31 May 2008
39				STS-126	14 November 2008	STS-126	14 November 2008
40				STS-119	15 March 2009	STS-119	15 March 2009
41				STS-125	11 May 2009	STS-125	11 May 2009
42				STS-127	15 July 2009	STS-127	15 July 2009
43				STS-128	28 August 2009	STS-128	28 August 2009
44				STS-129	16 November 2009	STS-129	16 November 2009
45				STS-130	8 February 2010	STS-130	8 February 2010
46				STS-131	5 April 2010	STS-131	5 April 2010
47				STS-132	14 May 2010	STS-132	14 May 2010
48				STS-133	24 February 2011	STS-133	24 February 2011
49				STS-134	16 May 2011	STS-134	16 May 2011
50				STS-135	8 July 2011	STS-135	8 July 2011
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100