Skip to main content
Solved

Create a formula for a view that only shows specific dates

  • May 8, 2023
  • 2 replies
  • 28 views

Forum|alt.badge.img+4

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.

Best answer by kuovonne

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.

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

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • May 8, 2023

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.

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


Forum|alt.badge.img+4
  • Author
  • New Participant
  • May 9, 2023

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