PDA

View Full Version : Computed Fields


JGM22
10-16-2012, 08:24 AM
I have created a field called 'Date Closed' which is just the date and time on when I complete a task. I also have another field called 'Date Due'. Is there a way to create an advanced search that will show overdue tasks based on the Date Closed is past the Date Due ( date and time )?

ie:

Date Due 10/15/2012 4:00 PM
Date Closed 10/16/2012 7:30 AM

This task would be late/overdue and I want this Item to show up in the Advanced Search.

Thank you for your time and input, much appreciated.

kinook
10-16-2012, 09:20 AM
No, there isn't way to search on one attribute compared with another attribute value.

JGM22
10-16-2012, 09:33 AM
Thx, maybe this could be added for future versions.

I created a field and run a search to see if the field is not blank to determine if the tasks are overdue ( I only add text to that field if the task is overdue ).