Kinook Software Forums

Kinook Software Forums (http://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (http://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   Date Math Search Problem (http://www.kinook.com/Forum/showthread.php?t=826)

wussery 01-26-2005 11:34 PM

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?

kinook 01-27-2005 03:43 PM

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

wussery 01-27-2005 08:23 PM

Quote:

Originally posted by kinook
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.

kinook 01-28-2005 09:13 AM

1 Attachment(s)
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 01-28-2005 09:04 PM

Quote:

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 02-02-2005 09:48 AM

All the date comparison issues should be resolved in 1.2.


All times are GMT -5. The time now is 03:42 AM.


Copyright 1999-2019 Kinook Software, Inc.