Show up today but delayed time

Hi,

I have slice called (Issues Log Weekly) when the super user (can see all of the new and old data entry )** adds a new entry on (date 24/08/21), this new entry filters just the 5 newest entries for the user read only for the next day**(25/08/2021)** to give the admin user a chance to check the new entries before it shows up for the next day (25/08/2021) Please see below Please see below


For that I used row filter condition please see below

My question is that I want to do the same thing but the newest 5 entries show up on the same day but delayed the time (end of day at 17:00 PM for example).

Any help for changing this expression: AND(([Timestamp] >= (TODAY() - 5)), ([Timestamp] <= TODAY())) for today but time delayed to 17:00 PM

Thanks

Not sure if I’m on the right lines here but…

IF(
Timenow()>="17:00:00",
X,
Y
)

You need to pick what forumlas X and Y need to be

Simno@1minManager.com

2 Likes

Hi,

Thank you for your reply the correct expression is:

AND(([Timestamp] >= (TODAY() - 5)), (TIMENOW() >= “17:00:00”))

3 Likes