Date issue

[tpoettker]

I am feeling really stupid right now. I have data with ARCAll = 1/27/2010, 1/28/2010, 1/2/2010 and 1/29/2010.

I have the following query which retrieves no records:

SELECT fqry_ARCall_list.ARCallID, fqry_ARCall_list.ARCallDate, fqry_ARCall_list.ARCallTypeID, fqry_ARCall_list.BillCompany, fqry_ARCall_list.ARCallPerson, fqry_ARCall_list.ARCallNote
FROM fqry_ARCall_list
WHERE (((fqry_ARCall_list.ARCallDate)>=Format(1/2/2010,"mm/dd/yyyy") And (fqry_ARCall_list.ARCallDate)<=Format(2/2/2010,"mm/dd/yyyy")));


What am I missing?

[Pradeep1210]

Instead of things like Format(1/2/2010,"mm/dd/yyyy")
use #1/2/2010#

There's a difference between the two:
The first one is a string (date formatted as string) while the second one is a date (internally stored as number)

[tpoettker]

It worked. Thank you!!!