How to filter emails using Get Mail activity date Query property by date

[ilanaribeiro95 (Ilana Ribeiro)]

Need to consume emails by a specific date. Can I filter emails using the query by date? Has anyone done this?
I searched on other forums and didn’t see anyone doing the same.

[Areej_fatima]

Kindly try with this string format in filter property buddy
" [ReceivedTime] >= ‘02/23/2018’ AND [ReceivedTime] <= ‘02/25/2018’ "

[hafiz.ahsan (Hafiz Mohammad Ahsan)]

You have to put the below code in the filter option of Get Email properties:

“[ReceivedTime] >= ‘write starting date here’ AND [ReceivedTime] <= ‘write ending date here’”

[Gokul001 (Gokul Balaji)]

Hi @ilanaribeiro95

Welcome to Uipath community

Check out the documentation

Get Outlook Mail Messages

Regards
Gokul

[ilanaribeiro95 (Ilana Ribeiro)]

@Areej_fatima

" [ReceivedTime] >= ‘02/23/2018’ AND [ReceivedTime] <= ‘02/25/2018’ "

did not work

[poorna_nayak07 (Poornachandra M)]

Hi @ilanaribeiro95,

Try using in below format
" [ReceivedTime] >= ‘02/23/2018 00:00 AM’ AND [ReceivedTime] < ‘02/26/2018 00:00 AM’ "

[ilanaribeiro95 (Ilana Ribeiro)]

is it necessary to specify the exact time?

[Yazan_Ghazal]

can you share workflow with us to help you

[ilanaribeiro95 (Ilana Ribeiro)]

“ReceivedDateTime ge 2022-07-12T00:00:00Z and ReceivedDateTime lt 2022-07-13T00:00:00Z”

I did this and it worked