How to get last hour data

Help Studio
, ,
1

Hi,

I need to get the last hour from “Action_time” column of an excel file of today’s date.
format should be fixed.

You have to change time and date when you contruct code.
for ur refrence i am giving the file.
New Microsoft Excel Worksheet (2).xlsx (12.4 KB)
here in this file u see the output sheet from that u will understand what I am trying to say.

let’s take some example: suppose today’s date is 24-11-2022 and the time is 7.05 pm
here I am downloading the file from browser in which I which date time column where I have to filter last hour data i.e. (6 pm to 7pm) date will be today’s date.

1 Like
2

Hi,

How about the following sample?

image
image619×552 16.4 KB 

dt = dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("Action_time").ToString)>=currentDateTime.Date.AddHours(currentDateTime.Hour-1) AndAlso DateTime.Parse(r("Action_time").ToString)<currentDateTime.Date.AddHours(currentDateTime.Hour)).CopyToDataTable()

Sample20221124-4aL.zip (12.5 KB)

Regards,

1 Like
3

can u please tell me why u use this “New DateTime(2022,11,24,19,5,0)”

1 Like
4

Hi,

This is for your assumption.

suppose today’s date is 24-11-2022 and the time is 7.05 pm

In actual use, it should be Now instead of New DateTime(2022,11,24,19,5,0)

Regards,

5

ok
I’ll try in my code

6

I am doing this “CDate(Now.ToString(“dd-MM-yyyy”))”

what I am doing wrong
please tell me

7

Hi,

Can you try to modify as the following?

CurrentDateTime = Now

Then use same expression.

dt = dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("Action_time").ToString)>=currentDateTime.Date.AddHours(currentDateTime.Hour-1) AndAlso DateTime.Parse(r("Action_time").ToString)<currentDateTime.Date.AddHours(currentDateTime.Hour)).CopyToDataTable()

Regards,

1 Like
8

when I am doing CurrentDateTime = Now it shown an error in your code as well as in my code.

9

HI,

Can you share screenshot of the error?

Regards,

10

Assign: The source contains no DataRows.

Screenshot (72)
Screenshot (72)1920×1080 210 KB

1 Like
11

Hi,

This mean there is no row as filter result.
The above expression assumes there is one or more rows as result.
Can you try as the following?

image
image771×446 15.5 KB

Please replace .CopyToDataTable with .ToArray

arrDr = dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("Action_time").ToString)>=currentDateTime.Date.AddHours(currentDateTime.Hour-1) AndAlso DateTime.Parse(r("Action_time").ToString)<currentDateTime.Date.AddHours(currentDateTime.Hour)).ToArray()

Then check arrDr.Any() using If activity

note: arrDR is dataRow array type.

Regards,

12

Nothing Happen

here is the Xaml file.
Sample20221124-4aL.zip (19.1 KB)

13

Hi,

In my environment, it works well as the following.
(I modified now to currentDateTime = New DateTime(2022,11,25,16,30,0) because current local time is 23:40 in my place.

image
image1159×597 53 KB

Can you try again and check your input file if there is rows which should be extracted?

Regards,

1 Like
14

I did not get the solution yet of that problem so please help me

1 Like
15

HI,

Can you share your latest sample data?

Regards,

16

New Microsoft Excel Worksheet (2).xlsx (10.9 KB)

17

Hi @Lakshya_Garg2

May I know that is your output time changing from 13 to 14?

cheers

18

Hi,

I’d like confirm the following is same as what you expect.

As input data is 2022/10/25, target date is set as 2022/10/25 15:10:00 as the following.

img20221129-1
img20221129-11349×958 67.8 KB

Then the following is result data. Is this what you expect?

image
image1137×170 6.93 KB

If you need to filter it as actual current time, please modify it like Now instead of New DateTime(2022,10,25,15,10,0)

Sample20221124-4aL.zip (22.2 KB)

Regards,

19

yes u can change time according to ur system time