Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-26-2005, 11:34 PM
wussery wussery is online now
Registered User
 
Join Date: 01-17-2005
Posts: 36
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?
Reply With Quote
  #2  
Old 01-27-2005, 03:43 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
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>
Reply With Quote
  #3  
Old 01-27-2005, 08:23 PM
wussery wussery is online now
Registered User
 
Join Date: 01-17-2005
Posts: 36
Quote:
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.
Reply With Quote
  #4  
Old 01-28-2005, 09:13 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
I've attached the test database I used. The Advanced Search item matches one task, 'test task'. Does it find work differently for you?
Attached Files
File Type: zip testdate.zip (86.7 KB, 1376 views)
Reply With Quote
  #5  
Old 01-28-2005, 09:04 PM
wussery wussery is online now
Registered User
 
Join Date: 01-17-2005
Posts: 36
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.
Reply With Quote
  #6  
Old 02-02-2005, 09:48 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
All the date comparison issues should be resolved in 1.2.
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 05:59 AM.


Copyright © 1999-2023 Kinook Software, Inc.