Outlook 2003 views : sql filter

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%'
 AND
"urn:schemas:calendar:dtstart" >= '1/01/2006 0:00'
AND
"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.
 
 
coppensgAsked:
Who is Participating?
 
David LeeCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.