How to get outlook email for a particular day

[jsapkota]

I am trying to get Outlook emails using the ‘Get Outlook Mail Messages’ activity. My requirement is to get all emails for a particular day.

For example, if the current date is 05/21/2020, I need to get emails that were received on 05/20/2020.

I tried to use Filter as given below

"[ReceivedTime] >'"+Now.AddDays(-2).ToShortDateString+"' AND [ReceivedTime] <'"+Now.ToShortDateString+"'"

However this includes emails received on 05/21/2020 as well.

So my question is how to get all emails for the day - current date?

[kadiravan_kalidoss (Kadiravan K)]

Read emails from outlook received on “current date”

Hi @Amarjeet, I have attached an example that filters the messages according to the date they were sent. Could you please check it and tell us if it’s what you need? Main.xaml (8.4 KB) [image]

[jsapkota]

Hi Kadiravan,
Thanks for sharing.

Yah could check date using for each. However, I need to run through all the emails since the beginning. I just want to get emails from a particular day then traverse through them to processing further.