> Is there a “better” or different way to do this?

All of the dates have a timestamp of 12:00:00 AM, right? If your date range parameters are of type Date, SQL will stick 12AM in as the time. So you shouldn't have to worry about the time at all for comparison-sake. Everything will be 12AM.

BTW -- if you define the field type in the view as a "D" instead of "T", then VFP will just give you the date portion in the view.