I am search Outlook using interop and I’m trying to filter emails based on date & time, including down to milliseconds, but it appears not to be supported.
I have the following filter, if I remove the sub-second component it works – it does not return anything, but with the ‘.1234’ it is returning everything in the Inbox.
urn:schemas:httpmail:datereceived > '2023-01-09 13:22:22.1234' and urn:schemas:mailheader:subject like '%Example Test Email'
Is it possble to filter/search using sub-second values?
>Solution :
Is it possble to filter/search using sub-second values?
Nope. Outlook evaluates date-time values according to the time format, short date format, and long date format settings in the Regional and Language Options applet in the Windows Control Panel. In particular, Outlook evaluates time according to that specified time format without seconds. If you specify seconds in the date-time comparison string, the filter will not operate as expected.