Temporary User view

Hi,
Any idea how to hide the new data record rows for the user view like 1 day (24 hours)temporary ?

Thanks

Hi,
Hope It will work.
You can use the security filter for hiding the data to the user.

1 Like

Assuming you’ve got a column that records creation as a date time, simply use a slice with this formula:

DATE([CreationDateTime])<Today()

This will only show records for yesterday and older. If you want it to be 24hours exactly thats a bit more complicated :wink:

Simon@1minManager.com

3 Likes

In addition for this :wink:

Please see section " Examples that Compare Dates, Times, and DateTimes"

The example from this section:

  • [Timestamp] > (NOW() - 1) : a Yes/No value indicating whether the DateTime value of the Timestamp column is within 24 hours of the current date & time.
3 Likes

@Aurelien is right this is the simpliest way to do it. Not one I’ve really used

What I’d normally do is calculate the difference between the timestamp and Now() as a decimal then see if its > 24.00. Defiantely more complicated but sometimes later on you might need a formula that can check for any duration rather than just exactly 24hours

2 Likes

Agree :100:

1 Like