HI all,
I have one excel file. In that excel column name “Transaction Date” How to get start date and end date in that column. for example
02/01/2020
05/01/2020
01/01/2020
Like that it will be there I want to first value 01/01/2020 and last value 05/01/2020 can you solve the solution for me.
First Sort the data Table using “Sort DataTable Activity” …
After use for each row Activity in that use get row Item…
Thankyou @Shubham_Akole
If you get Solution Then Mark as Solution…To Help Other…
i sort that column using sortdatatable and how to get start date and end date
Can your share excel file what exactly you want…
New Microsoft Excel Worksheet.xlsx (11.4 KB)
I want that first row value 01-01-2020 and last row value 20-01-2020
In your excel no dates is available…I think you share wrong excel
date.xlsx (56.1 KB)
did you see that file @Shubham_Akole
Yes.
From that what you want…
First i want to sort ascending order then i want to First row value and last row value in that excel. I tried using Read cell but it’s showing string cannot be converter datetime
First row value means ----small Value…
Last row value means -----Largest value …
Right?
yeah correct @Shubham_Akole
I have created one workflow which gives the below output :-
I have attached the workflow for the same :-
Main.xaml (11.7 KB)
Make this as solution and like it 
Happy Automation 
Best Regards
Er Pratik Wavhal 
yeah I will check and let you know @Pratik_Wavhal Thankyou so much.
First Use Read Range Activity To read the File
Create 1 string Variable …
Str variable =DatetableVariable.AsEnumerable().Max(Function(row) Convert.ToString(row(“Column Name”)))
For small value change Max function to MIN…
Thankyou @Shubham_Akole.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
Sekoleyte
prashant1603765
adi.mehare
ashokkarale
Darshan_Sable
V_Roboto_V
Achiranga
mively
Logesh_Velu