Unable to filter using last 4 hours in excel

[girishankar09]

I have an excel sheet 1 with data which I would like to filter with last 4 hours data and past it in the sheet 2

I tried it but unsuccessful. Attached the file and Main flow, could you please help
Main.xaml (13.7 KB)
Log.xlsx (27.3 KB)

[Yoichi]

Hi,

Can you try the following sample?

arrDr = dt.AsEnumerable.Where(Function(r) not String.IsNullOrEmpty(r("Change time").ToString) AndAlso DateTime.ParseExact(r("Change time").ToString,"MMMM d, yyyy h:m:s tt \U\T\C",System.Globalization.CultureInfo.InvariantCulture)>DateTime.UtcNow.AddHours(-4)).ToArray()

Sample20230624-1aL.zip (17.8 KB)

Regards,