What is the filter expression for get exchange mails

[sathish_Kumar6 (sathish Kumar)]

For example i want to get one date to another date in get exchange mails

Like for example i give dates for input dialogue box and another date in dialogue box so my final output should be stored in one expression, like for ex i give input as 24-10-2022 to 28-10-2022 so for this how to write expression in exchange get mails to get from inbox?

Also i want to get dates like from sent items so for this i have to give input date only so for this how to write filter expression

[Sudharsan_Ka]

HI @sathish_Kumar6

Here are some of the examples

Get Exchange Mail Messages

You can also try this
get the mails and loop through with for each (property as Net.Mail.Message) and use if condition inside for each and give your condition and process it

Regards
Sudharsan

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

You can filter using “received: >=10/24/2022 AND received: <=10/28/2022”.

you can get the values from the dailog box and then do a concat like “receivd: >=” + value1 + “AND received: <=” + value2

Or Alternately get all mails and loop through and use if condition

cheers

[sathish_Kumar6 (sathish Kumar)]

@Anil_G

received: >=10/24/2022 AND received: <=10/28/2022

thanks for the reply, sorry for the delayed response but im getting dates as from 25 not 24

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

Try changing the date in filter and also check if there are any mails on that day.

Should help

Please mark solution and close the thread as others can also get help

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

cheers

[sathish_Kumar6 (sathish Kumar)]

@Anil_G

“received: >=10/24/2022 AND received: <=10/28/2022”

“received: >=10/24/2022 AND received: <=10/28/2022”

im getting output in mentioned excel format but could you let me know like how to convert? dd/mm/yyyy hh:mm:ss

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

You can use before pasting write datevar.Tostring(“dd/mm/yyyy hh:mm:ss”)

and also make sure in excel the cell format is proper

If not add a '(single quote infront of the date so that excel thinks it as string and will not reformat

cheers

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

Can we close this please. As for one type of question one thread needs to be used and then closed. If you have any more questions feel free to open new threads. That way answers can be segregated and made available for others as well

On top I have posted how to mark a solution and close. Please follow the steps

cheers

[Gokul001 (Gokul Balaji)]

Still he did not get the Answer not correctly @Anil_G

@sathish_Kumar6

“received: >=10/24/2022 AND received: <=10/28/2022”

The data is not filtered properly right ? @sathish_Kumar6

[Anil_G (Anil Gorthi)]

Hi @Gokul001

The filter is working he needs how to format the date.

FYI - What is the filter expression for get exchange mails - #4 by sathish_Kumar6

cheers

[Gokul001 (Gokul Balaji)]

@sathish_Kumar6

response but im getting dates as from 25 not 24

Can you look over post of @sathish_Kumar6

@Anil_G

[Anil_G (Anil Gorthi)]

Hi @Gokul001

Yes please. I did and its more on getting mails between dates. I dont mind giving the same on elaboration but crux is solved I believe

cheers

[sathish_Kumar6 (sathish Kumar)]

okay thanks i will create new topic for this @Anil_G

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

For dates you need not as well satish. This is more to give better solution for the problem that anyone has. Happy Automation.

Happy to solve the issues any time. @sathish_Kumar6 thanks for the reply again on clarifying it

cheers

[sathish_Kumar6 (sathish Kumar)]

i know im not good at dates so im sorry

[Anil_G (Anil Gorthi)]

Hi @sathish_Kumar6

Totally understandable. We are all on same page. We learn daily.

cheers

[Gokul001 (Gokul Balaji)]

Hi @sathish_Kumar6

For Date check out this expression

DateTime.ParseExact(StringInput.ToString,"ddd, dd MMM yyy HH:mm:ss K",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy hh:mm:ss")

Check out the tutorial

Recollect the basics of Date Format, String Manipulation and LINQ

Hello Everyone, I would like to present this post who are looking for the expressions related to the Date Format, String manipulation and LINQ Basic of Date formatting In this below topic, you will learn about Date Formats Convert datetime to week of year System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.Fi…

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (https://forum.uipath.com/t/all-about-datatable-uipath/386445) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm…

Regards
Gokul

[sathish_Kumar6 (sathish Kumar)]

thanks for the reply…i tried but i got some assign errors

[Gokul001 (Gokul Balaji)]

You can create the new topic for that error.

Thanks

[sathish_Kumar6 (sathish Kumar)]

sure thanks