Function / criteria to give me records from the last 90 minutes

Question

I have a time/date field in my select query and I want to set the criteria to only return records from the last 90 minutes. What criteria should I use?

Answer 1

You'll want to use the DateDiff function to do the comparison. Something like:

... WHERE DateDiff("n", RecordDate, CurrentDate) <= 90 ...