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
