Forum Discussion

AnnaliseSansouc's avatar
AnnaliseSansouc
Qrew Member
2 years ago

Formula Issue

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
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    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
    ------------------------------
    • AnnaliseSansouc's avatar
      AnnaliseSansouc
      Qrew Member
      2 years ago
      Thank you so much!! That makes so much sense and I'm kicking myself for not realizing this. I so appreciate your help!

      ------------------------------
      Annalise Sansouci
      ------------------------------