Find the maximum and minimum dates in a datatable

[divyaag (Divya)]

Hi All

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

[arivu96 (Arivazhagan A)]

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

dataTable.AsEnumerable().Min(Function (drRows) DateTime.Parse(drRows.Item([YourColumnIndex/Name]).ToString)).ToString

Regards,
Arivu

[divyaag (Divya)]

@arivu96

Convert.ToDateTime(dataTable.Compute(“MAX(TheDateColumnName)”, null))

Hi @arivu96

Thanks for helping me out …
I have tried Convert.ToDateTime(dataTable.Compute(“MAX(TheDateColumnName)”, null)) to assign one datetime variable. but am getting the below error

. Kindly help me

[nadim.warsi]

@arivu96

Convert.ToDateTime(dataTable.Compute(“MAX(TheDateColumnName)”, null))

Try - System.DBNull.Value.ToString instead of null

[balupad14 (Balamurugan)]

Hi @divyaag,

Here I have sample to get the Max and Min date from datatable Using the BalaReva.Datatable.Activities.

MaxMin.zip (2.6 KB)

Note :

After opened the Project please install the below package and save it. Reopen the project.

BalaReva.DataTable.Activities

Hi Friends. I have included some activities in the package of BalaReva.Datatable.Activities You can see in the below namespace [image] The key advantages are below 1.ConvertInputColumn - When you read the data from excel , it is always string format. Using this property can able change the data type and do the aggregation . 2.NullValue - If you have empty of null value in the data. can able to assign the default value for it. 3.Select- It is place to keep the condition(Where) Sample Fil…

Regards
Balamurugan.S

[Divyashreem (Divyashree Muddagangaiah)]

As error clearly Saying the issue replace null with System.DBNull.

[balupad14 (Balamurugan)]

have you tried with my sample. or attached your xaml. I will check …

Regards
Balamurugan.S

[divyaag (Divya)]

Hi @balupad14

I have tried to execute the code but am getting the below package error… I have installed all the packages but not sure why am getting this. can you please help

[divyaag (Divya)]

Hi @Divyashreem

I have tried with that but still I was getting the error. So, I provided " " then it got resolved.

Thank you

[balupad14 (Balamurugan)]

Hi @divyaag,

Here I have attached the installation guide.

After finished the Installation restart the studio.

グループ集計 - #6 by balupad14

Regards
Balamurugan

[divyaag (Divya)]

Thanks @balupad14

[divyaag (Divya)]

Hi @arivu96,

am getting the below error, can you please help .

{
“message”: “Assign : Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “16:59:31”,
“processVersion”: “1.0.6850.25695”,
“fileName”: “test”,
“jobId”: “db0f027e-32b3-44c9-8667-fc0bdd58e1f0”,
“robotName”: “SALINDIA\LOTUSINFOTECHVINOTHK”
}

[arivu96 (Arivazhagan A)]

Hi @divyaag,

can you share your xaml file and input so i can give the correct solution.

Regards,
Arivu

[divyaag (Divya)]

Hi @arivu96

[test.xaml (12.2 KB)

Please find that file and kindly help me here

[divyaag (Divya)]

@ arivu96

actually am scrapping the datevalue from datatable and trying to find the highest value out of it.

Thank you

[VanithaRajakumar (VaniR)]

Hi All,
I get the same error as @divyaag.

Assign: Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.

Can anyone provide a solution for this pls?

[VanithaRajakumar (VaniR)]

Hi… The below solution from @arivu96 from another similar post solved my issue

Convert.ToDateTime(dt.AsEnumerable().Max(Function(row) row(“ColumnName”)))

Thank you

[chethan.chandran]

dataTable.AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item([YourColumnIndex/Name]).ToString)).ToString - Worked for me, thanks