Outlook receive date filter


I am trying to get previous day emails with certain subject. When i use the following filter i am getting the day before emails. For example today i running my filter to get 3/3/2020 emails , but i am getting 3/2/2020 emails too. i don’t what is wrong with the filter below.

“@SQL=”+"(urn:schemas:httpmail:fromname LIKE ‘%xxx@xxx.org%’) AND ((urn:schemas:httpmail:subject LIKE ‘%subject1%’) OR (urn:schemas:httpmail:subject LIKE ‘%subject2%’)) AND (urn:schemas:httpmail:datereceived >=’"+now.AddDays(-1).Date.ToShortDateString +"’)"

@MadhuK I’ve got a hunch! Does it pick up all emails from 3/2 and 3/3? Maybe it has something to do with the timezone :wink:

also this will pick emails using the time as well and not only the date part…

1 Like

Thank you, i resolved it using different filter.

1 Like

Hi can you share your filter please? I’m trying to do a similar case.