I am using GetIMAPMailMessage activity to read top 5 emails from Gmail. Getting all the data from emails like sender, subject, date etc.
When I try to use FilterExpression with below two statements, both of them are giving exception
“[ReceivedTime]>‘09/20/2021 18:14’” or
“[ReceivedTime] > “ +Now.AddDays(-1).ToString(“MM/dd/yyyy hh:mm tt”)+””
Getting below exception -
The IMAP server replied to the ‘SEARCH’ command with a ‘BAD’ response: Could not parse command
What am I doing wrong?
Try below expression.
“[ReceivedTime] > ‘”+ Now.AddDays(-1).ToString(“dd-MM-yyyy”)+"’"
Nope, again giving same exception
Try below steps.
Use Get IMAP Mail Message activity to read mails and will give output as List of Mail Messages.
And then try below expression.
LstMailMessages = LstMailMessages.Where(Function(x) CDate(x.Headers(“Date”)).ToString("dd-MM-yyyy) > Now.AdsDays(-1).ToString("dd-MM-yyyy").ToList
@lakshman - I got the solution. Since I am using GetIMAP Mail Activity, below filter worked
in filterExpression -
If I want to fetch emails since 20th Sept 2021 -
or If I want to fetch emails since 2 days -
"SINCE "+ DateTime.Today.AddDays(-2).ToString(“dd-MMM-yyyy”)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.