Date Math Search Problem

[wussery]

I have just built a Search button to find all To-Do's equal to Today's date. I have two To-Do's dated 1-26-05, but the search will not find the items, unless I change the date to 1-27-05. The logic is off by one day. Is this a bug?

[kinook]

You're right, date equals searches are off by one day. As a workaround, you can use

<date attr> less than or equal to <date>
and <date attr> greater than or equal to <date>

[wussery]

Originally posted by kinook
You're right, date equals searches are off by one day. As a workaround, you can use

<date attr> less than or equal to <date>
and <date attr> greater than or equal to <date>

I tried your suggestion and this does not work either. I can see the logic, but no go on my end.

[kinook]

I've attached the test database I used. The Advanced Search item matches one task, 'test task'. Does it find work differently for you?

[wussery]

Originally posted by kinook
I've attached the test database I used. The Advanced Search item matches one task, 'test task'. Does it find work differently for you?

I loaded the test file and after clicking on the start button it returns the task with a Due Date of 1-26-05. Today's date is 1-28-05, which means this item should be filtered from view. I am using Windows XP SP2. I am looking to build a filter that will only show items that are Due today using a Date Item different from Due Date.

[kinook]

All the date comparison issues should be resolved in 1.2.