How to get start date and end date in excel column

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

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

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 datetimestr

First row value means ----small Value…
Last row value means -----Largest value …

yeah correct @Shubham_Akole

Hi @Buvaneshwaran_R

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 :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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.