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 11 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 11 months ago

  • 0
  • 1
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.
Awesome. Please feel free to reach out to us if you need any kind of help.

Thanks,
Gaurav