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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.