Sign in to follow this  

Filter based on [TODAY] (Dynamic TODAY not STATIC)

Recommended Posts

Is there a way to create a FILTER option where I will set a list column (which is date) and I can choose < (less than) TODAY (not pick up a date from calendar nor chosing today's date) but expecting filter to dynamically update TODAY everyday...


So what I will report out on chart that how many groups past the date on list colum, but the filter date needs to update everyday... Forexample something might be due next week but filter will not catch < (less than) today, however of task is not completed then next week filter should catch it if TODAY automatically updates everyday...


Thank you for your response



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this