how to filter by date and time?

r

Solution 1:

You need to extract the time for the filtering on time. First fix:

filter(hour(Date_Measure) >= 18 & hour(Date_Measure) <= 6)

Next problem: a number can't be >= 18 and <= 6. You need or here. (Assuming you want night times. If you want day times, keep the & and switch your <= and `>=.) Second fix:

filter(hour(Date_Measure) >= 18 | hour(Date_Measure) <= 6)

Related

Flutter- GestureDetector not working with containers in stack
Add new users as members to GCP Cloud Identity Group using Terraform
Change of Variables on a boundary differential equation
Question about Pythagorean Triples with the same $c$ value
Expected value problem with two dice
Independent, Pairwise Independent and Mutually Independent events
A Question about the Cumulative Hierarchy.
Is the Product of a Compact Space and a Countably Compact Space Countably Compact?
Nontrivial homogeneous Vector bundle
An Infinite Cyclic Group has Exactly Two Generators: Is My Proof Correct?
Find probability density function of $Y=\sigma X+\mu$
Why is the limit of $\frac{1}{1-e^x}$ when $x$ approaches $0^+$ equal to $-\infty$? [closed]