开发者

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

开发者 https://www.devze.com 2023-02-13 05:18 出处:网络
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?You\'ll want to use the DateDiff f

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?


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

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

精彩评论

暂无评论...
验证码 换一张
取 消