Getting the duplicate vaues by comparing date from datatable

Help
1

Hi All,

I have to take the greater date record name if there is any duplicate valueCapture .
Can anyone @badita @vvaidya @aksh1yadav @Florent_Salendres @arivu96 please help me here.

Its bit urgent
Thank you

2

filterDT = origDT.AsEnumerable.GroupBy(Function(r) New With {Key.Record = r("Task Record Number")}).Select(Function (g) g.OrderByDescending(Function(r) r("Extended Date")).First()).CopyToDataTable()

1 Like
3

Hi @vvaidya,

Thanks for sharing the above but am facing some issues while writing copy to datatable method,
is it possible to share sample xaml file for this?

Capture1
Capture11189×319 22 KB

thank you

4

Keep typing…don’t look at intellisense. Let’s see if you still get the error.

5

Thanks @vvaidya. It worked for me.
I am trying to compare the dates with the current date. but somewhere its showing wrong data.
As per the condition, if the duedate is less than current date then it should show current date and if its greatrthan due date then it should show due date. but its giving reverse output
Kindly help
Can you please help here

dare
dare875×511 12.8 KB
testhh.xaml (14.0 KB)