Hi All I need to find the maximum and minimum dates in a datatable. Can anyone please help me in this @aksh1yadav , @vvaidya

Hi @divyaag , maxDate = Convert.ToDateTime(dataTable.Compute("MAX(TheDateColumnName)", null)) minDate = Convert.ToDateTime(dataTable.Compute("MIN(TheDateColumnName)", null)) Or dataTable.AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item([YourColumnIndex/Name]).ToString)).ToString d…

Find the maximum and minimum dates in a datatable

Help

balupad14 (Balamurugan (BalaReva)) October 8, 2018, 9:23am 10

Hi @divyaag,

Here I have attached the installation guide.

After finished the Installation restart the studio.

グループ集計 - #6 by balupad14

Regards
Balamurugan

Topic		Replies	Views
Get Min / Max Date from DataTable Activities excel , activities , question	8	3342	November 10, 2021
Select(find) max date from datatable Help	7	8715	October 29, 2018
Get Max and Min Date in Column Studio studio , question , activities_panel	16	1807	May 5, 2022
Maximum date Help activities	3	3652	February 21, 2019
Object must be of type string - DataTable Help	6	1866	September 12, 2019

Find the maximum and minimum dates in a datatable

Related topics