Outlook receive date filter

[MadhuK (Madhavi Karuturi)]

Hi

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 +“')”

[Mr_Meeseeks (Dan Fishkin)]

@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

[bcorrea (Bruno Correa)]

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

[MadhuK (Madhavi Karuturi)]

Thank you, i resolved it using different filter.

[ercan.nebiler]

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