Outlook Date Filter

[Santhi]

Hiii,
How to add Date filter from passing Config Key or else passing Variables in Get outlook mail messages activity.
I tried this scenarios.But i’m not getting output.
ex:
“[ReceivedTime]<= ’ " + “07/20/2018” + " ’ AND [ReceivedTime]>= ’ " + “06/19/2018” + " ’” (Don’t want hardcode the value.)

“[ReceivedTime]<=’”+(Config(“ToDate”).ToString)+“’ AND [ReceivedTime] >=’”+(Config(“FromDate”).ToString)+“’” (Here i’m fetching the ToDate and FromDate through configFile. But This scenario not woking.)

I need to fetch the FromDate and ToDate value through Config file Or else any another options is there.

Thanks,

[KarthikByggari]

May be convert the string into DateTime variable and try to use in the filter condition.

Please check the below thread once -

Filter Outlook Email: Get Emails for the last 30 days

I have tried the filter in the UiPath Essentials Training - E-mail Automation 3.3 but it is giving me an error. my Filter: “[ReceivedTime] >= '”+now.AddDays(-30).ToString(“MM/dd/yyyy”) +“’” Error: Main has thrown an exception Source: Get outlook mail messages Message: Cannot parse condition. Error at “'05/05/2018’”. Exception Type: COMException System.Runtime.InteropServices.COMException (0x80020009): Cannot parse condition. Error at “'05/05/2018’”. at UiPath.Mail.Activities.GetMailActiv…

[Santhi]

Hii Karthik
I solved that issue

[Rashmi (Rashmi Pareek)]

@Santhi

Hi, from seeing the screenshot, I think ToDate and FromDate are variable but you put them in double quotes.

If they are variable then you have to remove them from double quotes or else they will work as a String .

Thanks