Hi
I have a query which should return records between two dates from a
single table. The date field is in "General date" format. If the start
and the stop dates have single digits for month and day then the querys
do not return anything, but if the day or the month have 2 digit values
they return the records correctly. I am also facing another problem. If
the start date does not have any values all records are displayed. In
the Settings --> control panel the date is specified in "M/d/yyyy"
format. The query i'm using is
SELECT * FROM Audit where (format(AuditDate,'Short Date') between
#2/2/2006# and #2/9/2006#)
please help
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
