Forum Discussion
MarkShnier__You
Qrew Legend
Close, but you should be using an IF statement for this kind of test.
IF(
[Departure Date]<=Today() and [Return Date]>=Today(), "ACTIVE",
[Departure Date]<Today() and [Return Date]<Today(), "PENDING",
[Return Date]<Today(), "INACTIVE")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
IF(
[Departure Date]<=Today() and [Return Date]>=Today(), "ACTIVE",
[Departure Date]<Today() and [Return Date]<Today(), "PENDING",
[Return Date]<Today(), "INACTIVE")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
bcloud
2 years agoQrew Member
Overcomplicating things I see...thanks for the assist!
------------------------------
bcloud
------------------------------
------------------------------
bcloud
------------------------------