Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Outlook 2003 views : sql filter

Posted on 2006-06-07
Medium Priority
Last Modified: 2012-05-05
I've created a view on my calender folder (outlook 2003) so that I only see the items with subject "leave" and started between 1/1/2006 and 31/12/2006.
("urn:schemas:httpmail:subject" LIKE '%leave%'
"urn:schemas:calendar:dtstart" >= '1/01/2006 0:00'
"urn:schemas:calendar:dtstart" <= '31/12/2006 0:00')

How can I modify it so that next year I don't have to change the "2006" in "2007" ?

I want something like this :
   "urn:schemas:calendar:dtstart" >= '1/01/' & year(now()) & ' 0:00'.
But that syntax is obviously not correct.
Thanks in advance.
Question by:coppensg
1 Comment
LVL 76

Accepted Solution

David Lee earned 1500 total points
ID: 17020922
Views don't support variables.  You could probably get around that by adding a user-defined that calculates whether the appointment is in the current year, and then filtering on that field.  I haven't tried this, but it should work.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
I came across an unsolved Outlook issue and here is my solution.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question