Filter for date and time

When filtering for a date or date range, you must enclose the date in hash marks:

Table: Filtering for a date

Expression	Operation	Value
=Injection_AcquiredDate	>=	=#01/25/2007#

If you do not provide a specific time of day, the system assumes the time #0:00:00#. Therefore, in order to filter for one entire day, you must filter for a date range as follows.

Table: Filtering for a date (single day)

Expression	Operation	Value
=Injection_AcquiredDate	>=	=#01/25/2007#
=Injection_AcquiredDate	<	=#01/26/2007#

It is not possible to filter for a time without using the date.