Date Math Search Problem
 

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?

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

less than or equal to
and greater than or equal to

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

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.

All the date comparison issues should be resolved in 1.2.