Applying filter in TIME variable.

[pappusrini]

Hello,

I'm trying to extract the data by applying filter between 8AM to 6PM in data set. Time variable is in TIME format. Any suggestions please?

Thanks in advance

Cnu

[novinosrin]

where time between '8:00't and '6:00pm't;

[Reeza]

Where time between ‘06:00’t and ‘18:00’t;

Note the t after the time to indicate a time value.

[pappusrini]

Thanks. Does it matter if the time variable is the “time part” of date/time variable?

I have the time variable as:

8Am
9Am

But this is the time part of date/time variable.

Thanks

[Reeza]

---

@pappusrini wrote:
Thanks. Does it matter if the time variable is the “time part” of date/time variable?

I have the time variable as:

8Am
9Am

But this is the time part of date/time variable.

Thanks

---

Try it.