Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Query - referring to an Act field in 'Value' dropdown of criteria.

New Member
Posts: 2
Country: USA

Advanced Query - referring to an Act field in 'Value' dropdown of criteria.

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?

 

Thank you!

Janelle

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Advanced Query - referring to an Act field in 'Value' dropdown of criteria.

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.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129