Skip to main content
Question

Formula Issue

  • Jul 7, 2022 8:46 PM UTC
  • 0 replies
  • 46 views

Hello all, I'm fairly new to QB so I apologize if this is a stupid question. Here is what I'm trying to accomplish. I have a list of dates and I need to capture dates within a 6 week time span. In essence, I want to be able to highlight events happening from now through the next 6 weeks, not including ones that have already passed. I first created a checkbox field which worked and would check the box when within that timeframe but didn't drop off past events. So I created this formula: 

If([Date]<=Today()+Weeks(6),"Current",

[Date]<Today(), "Past",

[Date]>Today()+Weeks(6), "Future")

The current and future work great but the past still isn't working for those dates that have passed. 

Open to any and all suggestions!

------------------------------
Annalise Sansouci
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
NP,
You were really close. QuickBase evaluates the IF from the top to the bottom and stops calculating once it hits the first test which is true. So we just need to resequence your IF statement.

If([Date]<Today(), "Past",


[Date]<=Today()+Weeks(6),"Current",




[Date]>Today()+Weeks(6), "Future")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------