Show between hours

Terry1
New Member

I have a slice tied to a UX view that shows only entries entered within the last 6 days. Iโ€™ve been trying and failing to figure out if there is a way to show only those entries if they are also entered before 11:00 am.

I have a Time Entered column to track the time when the entry is recorded, but I canโ€™t seem to make it work. Here is a screenshot of the expression Iโ€™m currently using:

Hoping someone can lead me in the right direction. Thank you.

0 3 371
3 REPLIES 3

Do it like [Time]<โ€œ11:00:00โ€

Terry1
New Member

Thanks Aleksi. I had tried that but I think I was adding AM to the expression. Works great now. Appreciate it.

Youโ€™re welcome

Top Labels in this Space