How can I split "Start Time" column with space, and then filter date today and today-7

Help
1

Hi , I am new user with RPA.

Could you kindly help, how can I split “Start Time” column with space, and then filter date today and today-7.

Exported excel data’s Date field is coming with “MM/dd/yyyy hh:mm:ss”.
I want to split “MM/dd/yyyy” as one column and hh:mm:ss as another column.
And then filter today date and today-7 date data.
Thanks!

Book1.xlsx (597.2 KB)

2

hi @kaungset

Start Time.split(“c)(0) = MM/dd/yyyy
Start Time.split(” "c)(1) = hh:mm:ss

If you use space as a separator and split it, that’s how it’s divided.

"Convert.datetime(Start Time.split(“c)(0)> Now.addday(-7)”

You can use the syntax to determine if it is -7 days from today.

gl

3

Hi,

Hope the following sample helps you.

Sample20200130-2.zip (451.1 KB)

Regards,

4

hi @Yoichi, thank you very much for your help!

when I try to run found the following error in assigning process;

(ERROR Compiler error(s) encountered processing expression “dt.AsEnumerable.Where(function(r) DateTime.Parse(r(“Date”).ToString) <= Today and DateTime.Parse(r(“Date”).ToString) >= Today.AddDays(-7)).CopyToDataTable”.
‘AsEnumerable’ is not a member of ‘System.Data.DataTable’. Main.xaml )

5

hi @David_Jang , thank i will try with you advice.

6

Hi,

Sometimes this error occurs for some reason. The following post helps to solve.

Regards,

7

Please find attached flowBook1.zip (460.9 KB)