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:sub ject" LIKE '%leave%'
AND
"urn:schemas:calendar:dtst art" >= '1/01/2006 0:00'
AND
"urn:schemas:calendar:dtst art" <= '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:dtst art" >= '1/01/' & year(now()) & ' 0:00'.
But that syntax is obviously not correct.
Thanks in advance.
("urn:schemas:httpmail:sub
AND
"urn:schemas:calendar:dtst
AND
"urn:schemas:calendar:dtst
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:dtst
But that syntax is obviously not correct.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.