Why do I have to add 1 to the todate of a query to get all

[ToyFox]

Wierd happening. I have a date field in a query and a form with two text boxes for date from and date to that are parameters to the query. For instance, if I want all records for December up to today, I I have to add 1 to the end date or go 12/1/2009 and 12/22/2009 as the date params.
I have seen this before but not lately. What am I doing wrong.

 

[SkipVought]

Can you see the actual SQL that runs, when you enter these parameters?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PWise]

if your date field is an date time field 12/21/2009 will give you just till 12/21/2009 12:00:00 am

 

[ToyFox]

ok very interesting

 

[ToyFox]

it is a date/time field. Thanks for the response.

 

[jsteph]

But keep in mind that if you enter all dates as just the date then even though there is a time component, you shouldn't need to add 1, ie, each date you would be entering into the table as the date plus 12:00 AM.

This is how it normally works so it looks like the data is getting entered with the time--possibly using a Now() function...
--Jim

 

[Hap007]

If it is a Date/Time Field, the Add 1 day to the field and do a 'Less Than' test '<'

That should also work.

Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[cdck]

Couldn't you also pull the data based on DateValue([Date field])? I believe I have used this in the past to make some queries ignore time data even if it's there.

Cheryl dc Kern