UiPath studio issue with date filtration which results in format exception

Help
1

I have an excel sheet which has a date column, where i need to filter it up for next 90 days that is from today to next 90 days records. when i tried writing the logic as
“Dattim.AddDays(90).ToString(“MM/dd/yyyy”)”
it is fetching the data but not in sequence and also the process is breaking with format exception. How can I solve this issue. kindly help, thanks in advance :slight_smile: Let me know for any further clarifications to solve this issue.

Regards,
Selva

2

Hey Selvarani,

please try this sample, I have created one for youMain.xaml (8.7 KB)
Main.xaml (8.7 KB)

regards
Aditya

3

let me know if you are facing any issue further!! :wink:

4

Hi Aditya,

Thanks for your quick response, but unfortunately this didn’t solved my problem.

Actually in my column i do have different dates, here in your workflow it is from current date + 1 till 90.

I have to check each and every date which is coming with my logic for within 90 days.

hope you are getting my point.

Regards,
Selva

5

hey Selvarani,

are you trying to select from combo box?
actually i’m not getting your problem yet!!
could you elaborate it again with scenario, it will help me out!!

regards
Aditya

6

I have a excel sheet which needs to be filtered for next 90 days from today’s date (to calculate expiry). I have a date column where dates are present in the form of MM/DD/YYYY. This filtration process should be dynamic because this process is going to be scheduled for every 1st and 15th day of the month. I will get new files every month with different data. so i want it to be filtered dynamically.

Attaching the dummy data for your perusal

12/31/2013
10/14/2014
10/21/2014
4/21/2014
11/2/2013
10/17/2014
10/22/2014
8/21/2014
10/22/2014
7/2/2013
8/24/2013
12/31/2013
6/21/2013
6/24/2014
11/17/2018
8/31/2013
9/30/2018
6/10/2018
7/20/2013
7/8/2013
12/31/2018
6/4/2014
6/12/2014
6/10/2014
6/10/2014
10/6/2014
7/1/2013
6/17/2014
5/9/2014
5/28/2014
5/31/2014
6/30/2014
12/6/2014

Regards,
Selva

7

Hi,

Any idea on this, kindly help.

Regards,
Selva