[AccessD] Using Between in a query

Ryan W wrwehler at gmail.com
Mon Aug 14 11:33:47 CDT 2017


When you do not enter a time, 00:00 is assume.  So "BETWEEN" 7/30/17 AND
7/31/17" means from 7/30/17 00:00 (midnight) until 7/31/17 00:00 (midnight)
so it does not account for the full day ahead.  They would need to enter
7/31/17 23:59 or 8/1/17



On Mon, Aug 14, 2017 at 11:27 AM, Kaup, Chester <
Chester_Kaup at kindermorgan.com> wrote:

> I have an interactive query where the user is asked to put in a start date
> and an end date. The query then uses the criteria of Between start date and
> end date. I am having a problem of some records not being retrieved. If the
> user puts in and end date of 7/31/2017 a record with a date of 7/31/2017
> 1:30PM is not retrieved. Does an end date of 7/31/2017 mean ending at 12:00
> PM on 7/30/2017? I guess I may not be fully understanding the use of
> Between.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list