Hi ,
I have an excel sheet which has the date column is in the format of M/D/YYYY, I want it to be filtered out for next 90 days from the various dates mentioned in the sheet . Kindly help me with the logic and which activity to use. Its quite urgent, kindly help me with your logic’s asap
Sample Input :
7/1/2013
4/30/2016
5/28/2014
10/22/2014
3/24/2014
10/23/2014
10/23/2014
9/30/2013
12/31/2014
11/5/2013
Thanks in advance 
Regards,
Selvarani M
@selvarani1390 Can u mention what will be output for the input u have mentioned.
Hi,
If my input is
3/24/2014
10/23/2014
10/23/2014
4/9/2019
1/8/2019
31/12/2018
9/30/2013
12/31/2014
11/5/2013
then my output should be,
1/8/2019
31/12/2018
I just need the exact next 90 days validation in order to check the expiry.
Kindly let me know if you need more information
Regards,
Selvarani M
@selvarani1390 U need to get dates from excel which are inside next 90 days validation from today or current date, right?
yes you are right !! i will have ‘n’ number of dates in the column which includes the next 90 days date, i want that to be filtered out. Hope you got my query.
Regards,
Selvarani M
@selvarani1390 yes i got ur query
Hi pathrudu,
Thank you so much for your help it means lot to me.
Regards,
Selvarani M
@selvarani1390 Sorry for the late reply please find the attached workflow.
date—.xaml (12.0 KB)
Hi Pathrudu,
When i try with the input created by us its working properly, when i try the same with my actual sheet i am getting the following error,
“If : String was not recognized as a valid DateTime”
exception type is format exception.
is there any other tweak we can use the formats to be changed as date followed by this logic.
Kindly help me to make this filtration the standard one.
Regards,
Selvarani M
can you please share me how you are getting in form of string when you are reading the date from your excel? in some formatted excels you might be getting date similar to this “48214” if so please let me know.
@Manjuts90
thanks for your response
the format which is wanted is M/D/YYYY example 8th October 2018 as in 10/8/2018 and 7th September 2018 as in 9/7/2018 not like 10/08/2018 and 09/07/2018
Regards,
Selvarani M
you can use the existing date time variable.tostring(“M/d/yyyy”) to get in the formate you required.
Hi Pathrudu,
I have attached the input dates for your perusal. kindly have this as input and run the workflow you shared.
Actually i doesnt know in which row this exception is coming since it has got 5000+ records.
Regards,
Selvarani MDates.xlsx (62.1 KB)
@Pathrudu that works Hurrayyy
Regards,
Selvarani M
@pathrudu if you dont mind it is possible for you tp discuss one more string split issue with regex please. Shall I share it 
Regards,
Selvarani M
sure.
@pathrudu thanks for your quick response.
My input sheet 1 will have the names like “Horton Jeremy jeremy.horton@example.com” i want it to be split up into
Last name : Horton
First name : Jeremy
Mail_Id : jeremy.horton@example.com
once it is been split i want it to be written in an excel sheet as Last name, First name in a single column by concatenating it
again i will have one more sheet 2 to compare , which will have the name column as in the formats of Last name, First name or First name , Last name.
what I need here is based on the sheet 1’s output (Last name, First name) i have to compare it with sheet 2 which has different format and make it right by overwriting it as in (Last name, First name)
once this process is done, again i need to compare sheet 1 and sheet 2 for the names and write the matched names in the format of Last name, First name in the new excel file.
Write it back for any clarification, your help will make a great difference in my work progression.
Regards,
Selvarani M
@selvarani1390
Check this!
Dates.xaml (11.2 KB)
sharazkm32
prashant1603765
V_Roboto_V
ashokkarale
Stef_99