I am in need to create a view that shows records only if the actual time is earlier than a specific time (7.00 pm) everyday. E.g.:if it is April 19th, 4.30 PM the records should be showed but as soon as It is 7.01 PM, April 19th’s data shouldn’t be showed anymore. As soon as the day changes to the day after (April 20th in our example) the new records should be showed until 7.00 pm and so on.
Does it make sense?
I have used the formula IS_BEFORE(NOW(),TODAY(‘D MMM YYYY 19:00’)) so I could add a filter to the view based on the formula outcome but I am not getting the correct result even if I am not getting an error.
Thank you so much @ScottWorld . It works!
I wonder if I can bother you with another question about what I am trying to obtain in AT regarding this process.
I am setting up 3 views (NEW, PENDING, PROCESSED).
In the NEW view I have all the requests that still have to be reviewed.
In the PENDING view I have requests that have been taken care of and that will be automatically sent to another team at 7.00 pm everyday (filters: your formula HOUR(NOW()) < 19 = true + a reviewed checkbox)
In the SENT view I need to show all the requests passed to the other team but this view shouldn’t include the requests in the pending view. They should be included only after 7 pm each day.