查询日期范围< = [英] Query date range <=

问题描述

嗨


我有一个表格，其中有两个字段代表日期范围，例如

20-7-09到26-7-09我我正在运行下面的查询并且它只返回从20-7-09到25-7-09的日期范围，因为你可以看到我在第二个字段上使用的是小于或等于标准，所以这理论上应该给我20个-7-09到26-7-09这个标准是正确的还是我只是愚蠢


问候Phill

Hi

I have a form with two fields that represent a date range for example
20-7-09 to 26-7-09 I am running the query below and it only returns the date range from 20-7-09 to the 25-7-09 as you can see I am using the less or equal to criteria on the 2nd field so this should in theory give me 20-7-09 to 26-7-09 Is this criteria correct or am I just being Dumb

Regards Phill

展开 | 选择 | Wrap | 行号

推荐答案

看看这个最近的帖子：按日期条件筛选表格

Take a look at this recent thread: Filter Form By Date Criteria

好吧，我想我已经解决了为什么它不起作用，因为包含来自outlook日历的数据的表存储日期如下


02/08/2009 13 ：00：00


这是从outlook复制的格式，我更希望保持这种格式，因为我已经在我的代码中使用它，它将是一个主要的疼痛格式你可以看到其他任何方式吗？


Cheers Phill

OK I think I have worked out why it is not working its because the table that contains the data which is sourced from an outlook calendar stores the date as follows

02/08/2009 13:00:00

This is the format that is copied from outlook and I would much prefer to keep it in this format because I have used it in my code throughout and it would be a major pain formatting it can you see any other way around it?

Cheers Phill

有一些说明，以确保您的用户输入日期正确的格式。然后，确保使用＃'。

Have some instructions to make sure your user enters the date in the correct format. Then, make sure you use the #''s.

这篇关于查询日期范围< =的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！