01-11-2011 12:22 PM
I'm creating a custom query where i'd like to see if the date in one field is older than a date in another field. The problem is, i cannot see a way to write the query to allow that. I want the query to return records where the 'Paperwork Returned' field is more recent than the 'Plan Delivered' field. Is there any way to accomplish this?
01-11-2011 01:18 PM
The advanced queries are boolian and don't have provision for doing an If - Then comparison. You could likely create a report template that would give you the desired list. Another option would be to use the contact list Export to Excel and then do the comparison in Excel.