I have queries for Filter Option in Get Outlook Mail Messages. I have gone through all of topic which is covered on forum, but non of them seems to be valid in my case.
I need to filter email for last 5 Hours Email from now. I have used all the possible solution in forum topic but does not seem to be working fine.
I have tried below Filters. None of them giving runtime and compile time error but, output count is always coming as 0. I am here to get some solution to it.
1 : “[ReceivedTime] > '”+now.AddHours(-5).toString(“D”)+”’" – working but not giving last 5 hours email
2: “[ReceivedTime] >’”+Now.AddHours(-5).ToString()+"’" –Not Working - Email Count = 0
3: “[ReceivedTime] >’”&Now.AddHours(-5).ToString()&"’" – Not Working - Email Count = 0
Along with this - one more question like is not accepted by [Subject] Filter ?
"[Subject] like ‘’%Test%" – Not working
Q: How to get received time of email, after using for each Item. There is no property to get received date. (like item.?)
S O L U T I O N
Please check the last comment of mine for all possible Solutions. I have put every solution at one place. Thank You!