>> 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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement