I am converting an app from MS Access 2000 to use a VB front end with SQL Server as the database.
I have two datetime fields ORDEROn and ORDEROff. When I subtract ORDEROn from ORDEROff in a SQL statement in MS Access I get the number of hours in decimal format. But SQL Server returns 1901-01-01 00:00:0.000 no mater what the values are in the two DateTime fields.
How can I make SQL Server return the number of hours and minutes of difference between these two fields?