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 ess...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNP,
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
------------------------------
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
------------------------------
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
------------------------------
------------------------------
Annalise Sansouci
------------------------------