>> 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.
Dan;
My problem is I am pulling data from SQL Server 2000 which is updated by an ASP application, using DateTime. Say I want to find all records created today. If I create a record after 12:00:00 AM my begin date has to be the day of interest and my end date has to be the following date. For a range of dates the end date has to be one day after the date of interest.
This report application is going to be used on a production line so I do not think they will have time to remember that! :)
My original solution works for now but I will still look for a different way to do it.
Tom
Previous
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