Select only current date time and within 1 hour

[JDong]

Hello Team,

I have the below table where I am calculating Now and Now - 1 hour. Now in my output I want to show only records that are current. That is based on the current datetime and also select corresponding Now-1 hour.

Value	Now	Now - 1 hour
100	22.01.2020 08:31	22.01.2020 07:31
101	22.01.2020 08:31	22.01.2020 07:31
102	22.01.2020 08:31	22.01.2020 07:31
103	22.01.2020 08:31	22.01.2020 07:31
104	22.01.2020 08:31	22.01.2020 07:31
105	22.01.2020 08:31	22.01.2020 07:31
106	22.01.2020 08:31	22.01.2020 07:31
107	22.01.2020 08:31	22.01.2020 07:31
108	22.01.2020 08:31	22.01.2020 07:31
109	22.01.2020 08:31	22.01.2020 07:31
110	22.01.2020 08:31	22.01.2020 07:31
111	22.01.2020 08:31	22.01.2020 07:31
112	22.01.2020 08:31	22.01.2020 07:31
113	22.01.2020 08:31	22.01.2020 07:31
114	22.01.2020 08:31	22.01.2020 07:31
115	22.01.2020 08:31	22.01.2020 07:31
190	21.01.2020 06:40	21.01.2020 05:40
191	21.01.2020 06:40	22.01.2020 05:40
188	19.11.2019 05:30	19.11.2019 04:30

Expected Outcome

Value	Now	Now - 1 hour
100	22.01.2020 08:31	22.01.2020 07:31
101	22.01.2020 08:31	22.01.2020 07:31
102	22.01.2020 08:31	22.01.2020 07:31
103	22.01.2020 08:31	22.01.2020 07:31
104	22.01.2020 08:31	22.01.2020 07:31
105	22.01.2020 08:31	22.01.2020 07:31
106	22.01.2020 08:31	22.01.2020 07:31
107	22.01.2020 08:31	22.01.2020 07:31
108	22.01.2020 08:31	22.01.2020 07:31
109	22.01.2020 08:31	22.01.2020 07:31
110	22.01.2020 08:31	22.01.2020 07:31
111	22.01.2020 08:31	22.01.2020 07:31
112	22.01.2020 08:31	22.01.2020 07:31
113	22.01.2020 08:31	22.01.2020 07:31
114	22.01.2020 08:31	22.01.2020 07:31
115	22.01.2020 08:31	22.01.2020 07:31

Thanks

[messi007]

@JDong,

Please see below.

Attached the workflow,

Hope that helps,

Regards,

[JDong]

Hi @messi007 

Thanks, but you see the last 2 rows. 

That should not be part of the data output.

[Emil_Kos]

Hi @JDong,

I have prepared a workflow for you:

[JDong]

Thanks @Emil_Kos 

I still see the last 2 rows which should not be part of the output. Any thoughts here ?

[atcodedog05 · Accepted solution]

Hi @JDong 

I think got an idea what you are looking for. You want to consider only recent now.

Output: same as expected

Workflow:

Hope this helps 🙂

[Emil_Kos]

Hi @JDong,

I was under impression that we should use only 2 columns in order to check the values 😀