Help

Re: Create a formula for a view that only shows specific dates

Solved
Jump to Solution
485 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joy_Reed
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.

I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between one month ago and 3 months from now.  How would I go about making this?

Many many thanks in advance.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

How exact do you need the time range to be? You can create a filtered view based on a date range without using a formula field.

kuovonne_0-1683565514055.png

I don't recommend using a formula field for this because you would need to use the TODAY() function, which can be resource intensive.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

How exact do you need the time range to be? You can create a filtered view based on a date range without using a formula field.

kuovonne_0-1683565514055.png

I don't recommend using a formula field for this because you would need to use the TODAY() function, which can be resource intensive.

Joy_Reed
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you!  This is a much more elegant solution than I was thinking.