Link to home
Start Free TrialLog in
Avatar of coppensg
coppensg

asked on

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.
 
 
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial