Outlook 2003 views : sql filter

Posted on 2006-06-07
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

    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

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    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…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now