Search for records using two date feilds that are within 48 hours of one another

[ant123]

Hi All,

Sorry to pester you again!

I want to create a query where I search by two 'date' feilds. I want to pull out all records where these two feilds are within 48 hours of one another. This is based on hospital data where the first date is the date of arrival in the emergency department and the second date the date of admission to the hospital. So a patient may arrive on 23rd Jan (23.00pm) and be admitted on 24th Jan (02.00am).



Would be really grateful for any suggestions!

Thank you :-)

[June7]

Use DateDiff function to calculate elapsed time in hours and apply filter criteria to that constructed field.

[ant123]

Hi June7 - thanks very much for your help. I am just trying to do what you suggested. I will let you know how I get on :-)