Community
Showing results for 
Search instead for 
Do you mean 
Reply

Writing Queries (using current date/week)

Highlighted
New Member
Posts: 1
Country: United Kingdom

Writing Queries (using current date/week)

[ Edited ]
I really need to learn to write queries for ACT 6 especially if there is an automatic way of using today's date (current date).  Are there any web sites I should know about or books I should have?, thanks, Si
Message Edited by SimplySimon on 06-28-2009 11:59 AM
Highlighted
Moderator
Posts: 4,395
Country: USA

Re: Writing Queries (using current date/week)

Hello,

 

Here are a couple knowledgebase articles on how to create advanced queries.

 

How Do I Create a Query?

Boolean Operators Used in Advanced Queries

Highlighted
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Writing Queries (using current date/week)

With ACT! 6, saved queries were static, there wasn't any way to include a variable like today's date. That option is available with the advanced queries in the latest version of the ACT! program, ACT 2009.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer