...
Column Type | Entered Value | Matches |
|---|---|---|
Date | <20191014 | Before 12:00am 14 Oct 2019 |
<201910 | Before 12:00am 1 Oct 2019 | |
<2019 | Before 12:00am 1 Jan 2019 | |
<=20191014 | Before 12:00am 15 Oct 2019 | |
>20191014 | At or after 12:00am 15 Oct 2019 | |
>=20191014 | At or after 12:00am 14 Oct 2019 | |
<>20191014 | Before 12:00am 14 Oct 2019 or at or after 12:00am 15 Oct 2019 | |
20191014 | At or after 12:00am 14 Oct 2019 and before 12:00am 15 Oct 2019 | |
>=20191014 <20191021 | At or after 12:00am 14 Oct 2019 and before 12:00am 21 Oct 2019 | |
<20191014 | >= 20191021 | Before 12:00am 14 Oct 2019 or at or after 12:00am 21 Oct 2019 | |
201902 | 201905 | At or after 12:00am 1 Feb 2019 and before 12:00am 1 March 2019 or at or after 12:00am 1 May 2019 and before 12:00am 1 June 2019 | |
Time | <1430 | Before 2:30pm |
<=1430 | At or before 2:30pm | |
>1430 | At or after 2:31pm | |
>= 1430 | At or after 2:30pm | |
<>1430 | Before 2:30pm or at or after 2:31pm | |
>=14 <16 | At or after 2:00pm and before 4:00pm | |
<14 | >=16 | Before 2:00pm or at or after 4:00pm |
| Note |
|---|
Time filtering with SQL Server If when filtering data from a SQL Server database you receive errors about the data types time and datetime being incompatible you can resolve this by setting
|