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
Here are some of the examples
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
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
thanks for the reply, sorry for the delayed response but im getting dates as from 25 not 24
Try changing the date in filter and also check if there are any mails on that day.
Please mark solution and close the thread as others can also get help
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…
“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
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
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
Still he did not get the Answer not correctly
The data is not filtered properly right ?
Can you look over post of
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
okay thanks i will create new topic for this
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
i know im not good at dates so im sorry
Totally understandable. We are all on same page. We learn daily.
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
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
My recent post on datatable [All About Datatable- UiPath] (
All about Datatable - UiPath) 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
(Output - string type - “dd/MM/yyyy hh:mm:ss”)
**To get only current da…
thanks for the reply…i tried but i got some assign errors
You can create the new topic for that error.