Community
Showing results for 
Search instead for 
Do you mean 
Reply

Writing Queries (using current date/week)

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
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

Platinum Elite Contributor
Posts: 6,652
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
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129