Query function with date filter
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRS
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/20001/1/200012/31/2002
8
9
Example with INCORRECT date filterExample with CORRECT date filter syntaxExample with CORRECT date filter syntax referencing date in separate cell (yellow)Example with CORRECT date filter between two datesGet 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
MissionLaunch DateMissionLaunch DateMissionLaunch DateMissionLaunch DateMissionLaunch DateMissionLaunch Date
12
STS-992/11/2000STS-992/11/2000STS-992/11/2000STS-51-C1/24/1985STS-947/1/1997
13
Where is the data?? Query is empty because date filter is incorrect
STS-1015/19/2000STS-1015/19/2000STS-1015/19/2000STS-61-C1/12/1986
14
STS-1069/8/2000STS-1069/8/2000STS-1069/8/2000STS-51-L1/28/1986
15
STS-9210/11/2000STS-9210/11/2000STS-9210/11/2000STS-321/9/1990
16
STS-9711/30/2000STS-9711/30/2000STS-9711/30/2000STS-421/22/1992
17
STS-982/7/2001STS-982/7/2001STS-982/7/2001STS-541/13/1993
18
STS-1023/8/2001STS-1023/8/2001STS-1023/8/2001STS-721/11/1996
19
STS-1004/19/2001STS-1004/19/2001STS-1004/19/2001STS-811/12/1997
20
STS-1047/12/2001STS-1047/12/2001STS-1047/12/2001STS-891/22/1998
21
STS-1058/10/2001STS-1058/10/2001STS-1058/10/2001STS-1071/16/2003
22
STS-10812/5/2001STS-10812/5/2001STS-10812/5/2001
23
STS-1093/1/2002STS-1093/1/2002STS-1093/1/2002
24
STS-1104/8/2002STS-1104/8/2002STS-1104/8/2002
25
STS-1116/5/2002STS-1116/5/2002STS-1116/5/2002
26
STS-11210/7/2002STS-11210/7/2002STS-11210/7/2002
27
STS-11311/23/2002STS-11311/23/2002STS-11311/23/2002
28
STS-1071/16/2003STS-1071/16/2003
29
STS-1147/26/2005STS-1147/26/2005
30
STS-1217/4/2006STS-1217/4/2006
31
STS-1159/9/2006STS-1159/9/2006
32
STS-11612/9/2006STS-11612/9/2006
33
STS-1176/8/2007STS-1176/8/2007
34
STS-1188/8/2007STS-1188/8/2007
35
STS-12010/23/2007STS-12010/23/2007
36
STS-1222/7/2008STS-1222/7/2008
37
STS-1233/11/2008STS-1233/11/2008
38
STS-1245/31/2008STS-1245/31/2008
39
STS-12611/14/2008STS-12611/14/2008
40
STS-1193/15/2009STS-1193/15/2009
41
STS-1255/11/2009STS-1255/11/2009
42
STS-1277/15/2009STS-1277/15/2009
43
STS-1288/28/2009STS-1288/28/2009
44
STS-12911/16/2009STS-12911/16/2009
45
STS-1302/8/2010STS-1302/8/2010
46
STS-1314/5/2010STS-1314/5/2010
47
STS-1325/14/2010STS-1325/14/2010
48
STS-1332/24/2011STS-1332/24/2011
49
STS-1345/16/2011STS-1345/16/2011
50
STS-1357/8/2011STS-1357/8/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
Loading...