Comparing two date fields in a SQL query
Posted on 2001-08-01
I'm using ADO in VB with an Access database. I need to compare two date fields in a query to see how much time elapsed between the two dates.
In other parts of the program I am using the DateAdd function to do this. In the query however I need something that I can use in SQL that will serve to provide the same functionality as DateAdd except in this case inside the query comparing whatever values are in the fields.