General information
Title:
Date range isn't inclusive
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only