The issue is actually about using dates and times in databases.
I've encountered the same problem many times in Crystal Reports.
The key thing to remember is that date fields in a DB can also store time
values, so if you are looking at selecting a date field, you msut allow for
any time values. If a time isn't specified it is 00:00am (ie.e midnight at
the start of the day). So any time that day is after midnight and therefore
is excluded.
It sometimes can be simpler to exclude the time portion of the date field
and select on that. Or if possible, use a time of 23:59 on the final date
you select from.
Cheers
Bruce
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
