M
Mark B
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)?
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)?