Forum Discussion

JudyJudy's avatar
JudyJudy
Qrew Trainee
6 years ago

How can I build this formula in quickbase. Field D and E are arrival and departure dates and I need to filter records within those dates

I can make this work in excel but don't see the "and" option in QB. =IF(AND(E7<=(D7-1),E7>=C7),"InHouse","Not InHouse") My goal is to have a report that only includes in house guests
Formulas and functions
JudyJudy's avatar
JudyJudy
Qrew Trainee
6 years ago
Thank you for the quick reply!  This worked perfectly.
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    6 years ago
    Awesome. Please feel free to reach out to us if you need any kind of help.

    Thanks,
    Gaurav