Filter mail outlook?

Example header mail : Sun, 23 May 2021 17:01:09 +0700

I want to filter mail receive time from today 17.00.00 - 17.10.00

Please guide me about it.

@fairymemay - Could you please share the similar screenshot of yours?

This is just to make sure, your header date format is correct before proceeding.


@fairymemay - Thanks…Please check the below is working and you can extract the time alone using this command…Please run for atleast 5 mails…


@fairymemay - I can see this query provided by @jack.chan is working for me…Could you please show me where exactly did you put this query with the screenshot?

@prasath17 If I use query for your mention.

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

But output can’t show follow filter.


@fairymemay - I am asking for the similar screenshot…

@prasath17 My screenshot.

@fairymemay - Looks good…Can you change to time now , as per requirement and see the result?

@prasath17 What format time HH:mm:ss right?


@prasath17 I change to query as below.

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

but output not show (not found)
But If I remove filter and write line header , it show below.

"@SQL=urn:schemas:httpmail:datereceived > '" + Now.ToString("ddd, dd MMM yyyy 17:00:00 +0700")+ "' AND urn:schemas:httpmail:datereceived < '" + Now.ToString("ddd, dd MMM yyyy 17:10:00 +0700")+ "'"

Please try this…

@prasath17 If I change filter follow you recommend.
I think it read all mail not filter time and date as below.

@fairymemay - In your case it should have resulted 0. because since you are running this today there won’t be any email at 17.00 and 17.10. Could you please change the filter time to 00:06:00 and 00:06:30 and try… and after the please share the screenshot of the filter properties…

@prasath17 I change time to 00:06:00 and 00:06:30 as below.

But output same.