MS Access查询以提取日期之间的记录 [英] MS Access query to pull records between date

问题描述

我正在使用Microsoft Query从Access数据库中提取数据.我正在尝试在明天的01:00:00和第二天的早晨00:00:00之间提取数据.我已经尝试了一切

I'm using Microsoft Query to pull data from an Access database. I'm trying to pull data between tomorrow at 01:00:00 and the following morning at 00:00:00. I've tried everything from

WHERE (acct_data.Date Between DATEADD(DAY,1, DateADD(HOUR,1, GETDATE())) And DATEADD(DAY,2, GETDATE())))

到

WHERE (acct_data.Date Between DATEADD(DAY,1, DateADD(HOUR,1, GETDATE())) And DATEADD(DAY,2, GETDATE())))

以及介于两者之间的所有内容(正确的代码除外).有谁知道从明天的凌晨1点到午夜获取数据的正确语法?

and everything(except the correct code)in between. Does anyone know the correct syntax to get data from tomorrow at 1AM to midnight?

在此先感谢您的帮助.

推荐答案

这将是MS Access语法:

This would be the MS Access syntax:

WHERE acct_data.Date >= dateadd("h", 25, now()) And 
      acct_data.Date < dateadd("d", 2, now())

这篇关于MS Access查询以提取日期之间的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！