I looking for a reference on what "SQL" functions I can use for the filter.
Namely , I need to use an IF statement (or CASE statement -- not sure which)
to inspect whether a field is null or not. If it is then I need to perform a
greater than () condition on an alternate field rather than the field in
question:

If Field BNULL then the condition is Field B1 Else the condition is Field
A1


"Ken Slovak - [MVP - Outlook]" wrote in message
...
All Outlook date/time properties are stored internally in UTC and
compensated to local time when retrieved using the Outlook object model.
In this case it would be easier to use a conversion of the time you want
to test to UTC for the comparison.

What syntax are you looking for a reference for?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Mark B" wrote in message
...
C#, VSTO, 2007

Our Add-in programmatically creates a Search folder that filters on a
user-defined field called "OurMileStone1DateTime":

today("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/OurMileStone1DateTime")%)

However OurMileStone1DateTime is a UTC Date/Time.

I am trying to figure out how I can edit the SQL above to convert
OurMileStone1DateTime to the user's local Date/Time so the filter will
then compare that to the user's today date/time.

Either that or maybe better, try for TodayUTC. In fact as I am writing
this post I think that may be better since it would involve less
calculation.

Any thoughts on how to do this using the specified syntax (which I
haven't yet been able to find a comprehensive reference document for)?