First the broad question then the specific one. Thanks to all for any help anyone might have.
I'm trying to understand the finer points of advanced filters when defining my own custom views for contact information, and I am having trouble understanding the syntax for the 'values' of the advanced filter. Does anyone know of a good web dictionary or other resource for this?
And now the specific question. We have a membership structure and membership will be expiring within 60 days. How do I create an advanced filter to report which agencies will be expiring in 60 days? I created a field (Join Date) that has the exact date of their expiration and I tried this:
Join Date is on or before today+60
Join Date is on or after today+60
Join Date is between today and today+60 (this seems like it should work!)
Any thoughts???
Thanks a lot!
LL Tool J
I'm trying to understand the finer points of advanced filters when defining my own custom views for contact information, and I am having trouble understanding the syntax for the 'values' of the advanced filter. Does anyone know of a good web dictionary or other resource for this?
And now the specific question. We have a membership structure and membership will be expiring within 60 days. How do I create an advanced filter to report which agencies will be expiring in 60 days? I created a field (Join Date) that has the exact date of their expiration and I tried this:
Join Date is on or before today+60
Join Date is on or after today+60
Join Date is between today and today+60 (this seems like it should work!)
Any thoughts???
Thanks a lot!
LL Tool J