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
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
Hi,
Thank you for your reply the correct expression is:
AND(([Timestamp] >= (TODAY() - 5)), (TIMENOW() >= โ17:00:00โ))
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |