How to read mail by time received mail?

[fairymemay (noona)]

I want to read mail from outlook.
Condition received mail time 13.00 - 14.00 and date today.

please guide me about it.

[prasath_S]

Hi @fairymemay

Please refer this

Get outlook mail messages filter by date

Hi All, Does Anyone knows how to filter the Outlook mail messages by date. ( range of Dates). I tried this **“received:>=02/23/2018 AND received:<=02/25/2018 **. ” in the outlook application search bar and it works but it doesn’t work in the get mail message object filter. Kindly requesting your help on this.

Thanks

[prasath_S]

@fairymemay Please try this and let me know if it not works,

“[ReceivedTime] >= ‘”+now.ToString(“ddd, dd MMM yyyy”)+" 00:00:00’ AND [ReceivedTime] <= ‘‘“+now.ToString(“ddd, dd MMM yyyy”)+” 00:10:00’"

Thanks

[jack.chan]

paste this into the Filter field to filter mails from today and set time from 00:00:00 to 00:10:00.

"@SQL=urn:schemas:httpmail:datereceived > '" + Now.ToUniversalTime.ToString("dd/MM/yyyy 00:00:00")+ "' AND urn:schemas:httpmail:datereceived < '" + Now.ToUniversalTime.ToString("dd/MM/yyyy 10:00:00")+ "'"

[fairymemay (noona)]

@jack.chan After fill filter not found email in output.

But in mail have received mail time 00:06:00 (hh:mm:ss)

Please guide me more.

[jack.chan]

how about this

"@SQL=urn:schemas:httpmail:datereceived > '" + Now.ToString("dd/MM/yyyy 00:00:00")+ "' AND urn:schemas:httpmail:datereceived < '" + Now.ToString("dd/MM/yyyy 10:00:00")+ "'"

[fairymemay (noona)]

@jack.chan Same , not found email in output.