Get Oulook Mail Filter For Last Month

Help
1

What expression can I use to get me all emails with a received date of last month?

1 Like
2

hi
welcome to uipath community
hope this wuld help you
the filter property of GET OUTLOOK MAIL ACTIVITY can be mentioned as
"[ReceivedTime] >= ’ " + now.AddMonths(-1).tostring(“MM/dd/yyyy”) + " ’ AND
[ReceivedTime] =< ’ " + DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString(“MM/dd/yyyy”) + " ’ "

–make sure that the TOP property is set with maximum number else we will be getting mail only to the count we have mentioned in that property even though we have more numbers of mail that that value in our mail box received more than the last month

Kindly try this and let know for any queries or clarification
Cheers @isharee

3

Thanks for the feed back however I wasn’t able to get that filter to work. The filter below worked for me…
“[ReceivedTime] >= ’ " + now.AddMonths(-1).tostring(“MM/01/yyyy”) + " ’ AND [ReceivedTime] <= '”+now.ToString(“MM/01/yyyy”)+“'”

4

typo mistake
"[ReceivedTime] >= ’ " + now.AddMonths(-1).tostring(“MM/dd/yyyy”) + " ’ AND
[ReceivedTime] =< ’ " + DateTime(Convert.ToInt32(DateTime.Now.Year), Convert.ToInt32(DateTime.Now.Month), 1).ToString(“MM/dd/yyyy”) + " ’ "

Cheers @isharee