How to filter the hours in datatable?

Help
, ,
2

Hi!

The problem with this scenario and the Filter DataTable activity is that operations like bigger than (“>”) are meant to be used with integers and maybe DateTimes.

Your operation is “Hours” > “09:01” - it resembles a TimeSpan (usually: “hh:mm:ss”).

I don’t know if or how you can use the Filter DataTable activity for this issue, but you can try to convert your String (“09:01”) to TimeSpan first (Possible To Convert String written "xx:yy:zz" To TimeSpan "hh:mm:ss"?), then check if the timespan is longer than your constant like this:
TimeSpan.TotalMinutes > (9*60+1) - Forum thread for reference

@Palaniyappan @KarthikByggari @ClaytonM - do you guys know how to solve this more elegantly?

Cheers, Lukas

1 Like