shreyaR
(Shreya Rao)
August 13, 2020, 1:14pm
1
Hi Team,
I am trying to filter while getting the outlook messages
" [ReceivedTime] = ‘“+Now.AddDays(-2).ToString(“MM/dd/yyyy”)”
I am trying the above code to filter messages in order to get the mails from 11th august but I am getting zero Mail retrieved
bcorrea
(Bruno Correa)
August 13, 2020, 1:25pm
2
Try filter like this:
[ReceivedTime] >= '2014-09-21 00:00'
Srini84
(Srinivas Kadamati)
August 13, 2020, 1:26pm
3
@shreyaR
Check below
“[ReceivedTime] >= '”+now.AddDays(-2).Date.ToShortDateString+"’ AND [ReceivedTime] <= ‘"+Now.Date.ToShortDateString+"’"
Hope this may helps
Thanks
1996
(Neelima G)
August 13, 2020, 1:27pm
5
Hi @shreyaR ,
Your trying filtering for the date two days ago for that you can try this methods and let me know
“[ReceivedTime] >= '”+now.AddDays(-2).Date.ToShortDateString+“’ AND [ReceivedTime] <= ‘”+now().Date.ToShortDateString+“’”
or
This is string format in filter property:
" [ReceivedTime] >= ‘08/13/2018’ AND [ReceivedTime] <= ‘08/13/2018’ "
Hope this helps,if it works, mark it as solution.
Thanks,
Neelima.
The below filter is working fine
“[ReceivedTime] > ‘”+ DateTime.Now.AddDays(-3).ToString(“MM/dd/yyyy”)+“’”
shreyaR
(Shreya Rao)
August 13, 2020, 1:53pm
8
I Tried but it’s not working
Still I am getting zero email
Srini84
(Srinivas Kadamati)
August 13, 2020, 2:09pm
9
@shreyaR
Can you share your mails screen and properties screen?
Thanks
bcorrea
(Bruno Correa)
August 13, 2020, 5:56pm
10
Make sure you removed the filter of taking only unread mail, and test with something very clear (date very old) like:
[ReceivedTime] >= '2014-09-21 00:00'