Community
Showing results for 
Search instead for 
Do you mean 
Reply

New query operators in ACT 2010 documentation

Master Commentator
Posts: 287
Country: USA

New query operators in ACT 2010 documentation

Hi,

 

I noticed that there are some new query operators, like day equals [ number] and older than [days]. I searched theonline help and knowledgebase, but did not see anything on them. Is there any documentation available for these new options?

 

Thank you

Moderator
Posts: 4,395
Country: USA

Re: New query operators in ACT 2010 documentation

The knowledgebase article below contains most of the operators.

 

Here is a list of operators not in the list with examples.

 

After Next [days]

Example: a value of 2 will find items two+ days after the current date.

 

Days Equals [number]

Example: a value of 1 will find items that are first of the month (10/1/2009, 5/1/2005)


Month Equals [number]

Example: a value of 3 will find items that in March


Older Than [days]

Example: a value of 2 will find items two+ days before the current date.


Years Equals [number]

Example: a value of 2010 will find items in the year 2010

 

How to Create a Query in ACT! by Sage 2010

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: New query operators in ACT 2010 documentation

PS - for those not yet using Act! 2010, Day =, Month =, and Year = were all added in Act! 2008.  Act! 2009 saw the addition of After next and Older than...