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

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
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

Photo of Judy

Judy

  • 60 Points

Posted 8 months ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 6,026 Points 5k badge 2x thumb
Hi Judy,

Welcome to the community.
Quick Base has And operator. You can find all Quick Base functions and operators here.

Try this one. 

IF(([Your Field Name]<=[Your Field Name])and ([Your Field Name]>=[Your Field Name]),"InHouse","Not InHouse")
You have to replace your Cell name with the Quick Base field.

Please let me know if you need any further assistance.

Thanks,
Gaurav Sharma
(Edited)
Photo of Judy

Judy

  • 60 Points
Thank you for the quick reply!  This worked perfectly.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Awesome. Please feel free to reach out to us if you need any kind of help.

Thanks,
Gaurav