Filter for time elapsed between 2 columns

  • Thread starter Thread starter Qaspec
  • Start date Start date
Q

Qaspec

I have Planned Start Time And Actual Start Time
I only want to return records where the Planned Start Time is equal to or
less than 48 hours from the Actual Start Time

Thanks for your help
 
I assume that this time fields include also the date, other wise you can't
know the different between two times unless they are both on the same day,
which mean up to 24 houres

In the query create another column that calculate the different between the
two fields

HoursDiff: DateDiff("h",[Start Time],[Actual Start Time])

That will return the different in hours, under that field create the criteria
<=48

To return all the records that are 48 and less
 
Back
Top