maxDate = Convert.ToDateTime(dataTable.Compute("MAX(TheDateColumnName)", null))
minDate = Convert.ToDateTime(dataTable.Compute("MIN(TheDateColumnName)", null))
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
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
Try - System.DBNull.Value.ToString instead of null
Here I have sample to get the Max and Min date from datatable Using the BalaReva.Datatable.Activities.
MaxMin.zip (2.6 KB)
After opened the Project please install the below package and save it. Reopen the project.
As error clearly Saying the issue replace null with System.DBNull.
have you tried with my sample. or attached your xaml. I will check …
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
I have tried with that but still I was getting the error. So, I provided " " then it got resolved.
Here I have attached the installation guide.
After finished the Installation restart the studio.
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.”,
can you share your xaml file and input so i can give the correct solution.
actually am scrapping the datevalue from datatable and trying to find the highest value out of it.
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?
Hi… The below solution from @arivu96 from another similar post solved my issue