This is because the datetime field has a value other that 12:00:00 AM, so
02/23/1999 < 02/23/1999 12:00:01 AM
is true. You probably need to specify a time for vp_end of 11:59:59 PM to get everything for that day.
HTH!
Mark
>I create a view for a report by using a SELECT statement that has a WHERE clause that filters on the date range that the user enters. The statement is WHERE calldate >= ?vp_start AND calldate <= ?vp_end. It works fine unless the call date is the same date as the vp_end date, that call doesn't get included. The user has to make the ending date one day past the date they want included. I tried using BETWEEN(), but had the same results. Calldate is a date/time field. I'm using VFP 5.0.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.