Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date range isn't inclusive
Message
From
23/02/1999 15:35:23
Patty Prendergast
Calif. Dept of Toxic Substances Control
Sacramento, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Date range isn't inclusive
Miscellaneous
Thread ID:
00190635
Message ID:
00190635
Views:
42
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
Map
View

Click here to load this message in the networking platform