I'm creating a custom view of calender for all my non-work appointments
which are a mix of
- Holidays
- Private appointments (where I've ticked the 'private' box in the
calendar item)
- Non-private appointments starting or ending after 18:00 regardless of
date.


I could do it by marking everything as private, but I need to see
things that cross the work/private line e.g. holiday.
There might also be work events that start or go on after hours that
would knock on to my personal calendar.
I could create a custom category of 'stuff that should be on my private
calender', but I don't want to have to manually apply that all the
time, hence an automatic view.

I can filter for the first two using the SQL tab of Filter:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("http://schemas.microsoft.com/exchange/sensitivity-long" = 2 OR
"urn:schemas:httpmail:subject" LIKE '%Holiday%'

But I'm struggling with the third part, the time.

doing this:

"urn:schemas:calendar:dtstart" = '18:00')) OR
"urn:schemas:calendar:dtend" = '18:00'))

doesn't work, (I get every date back) because I think Outlook needs a
specific date to work with times.

Any ideas?

Outlook doesn't provide any way to filter start times like that. COnsider giving those evening items their own category.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message oups.com...
I'm creating a custom view of calender for all my non-work appointments
which are a mix of
- Holidays
- Private appointments (where I've ticked the 'private' box in the
calendar item)
- Non-private appointments starting or ending after 18:00 regardless of
date.


I could do it by marking everything as private, but I need to see
things that cross the work/private line e.g. holiday.
There might also be work events that start or go on after hours that
would knock on to my personal calendar.
I could create a custom category of 'stuff that should be on my private
calender', but I don't want to have to manually apply that all the
time, hence an automatic view.

I can filter for the first two using the SQL tab of Filter:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("http://schemas.microsoft.com/exchange/sensitivity-long" = 2 OR
"urn:schemas:httpmail:subject" LIKE '%Holiday%'

But I'm struggling with the third part, the time.

doing this:

"urn:schemas:calendar:dtstart" = '18:00')) OR
"urn:schemas:calendar:dtend" = '18:00'))

doesn't work, (I get every date back) because I think Outlook needs a
specific date to work with times.

Any ideas?