【译文】在查询里以当前月份为条件

时　间:2012-04-23 08:47:28
作　者:周芳   ID：24526  城市：上海
摘　要:创建一个查询返回当月的所有日期的记录
正　文:

原作者：Juan Soto 翻译：周芳

【译文】在查询里以当前月份为条件

        那天,我需要创建一个查询返回当月的所有日期的记录。我不想编程使用开始日期和结束日期来查询,所以我想出了下面代码行，你可以直接粘贴到你的查询代码中：

Between CDate(Month(Date()) &  “/1/”  & Year(Date())) And DateAdd(“m”,1,CDate(Month(Date()) & “/1/” & Year(Date())))-1

        以上使用“Between And”的标准是计算当前日期的月初和月底。希望大家受用！

【原文】Criteria for the current month in a query
The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query:
Between CDate(Month(Date()) & “/1/” & Year(Date())) And DateAdd(“m”,1,CDate(Month(Date()) & “/1/” & Year(Date())))-1
The criteria line above uses the “Between And” operators to calculate the first of the month and the end of the month of the current date. Enjoy!