AnsweredAssumed Answered

Caculated field based on arrival and departure

Question asked by LisaSheard on Mar 26, 2012
Latest reply on Mar 26, 2012 by philmodjunk

Title

Caculated field based on arrival and departure

Post

I am trying to create a caculated field called Thursday night.  I want it to be based on the following: accomodations is a yes, they are arriving on Wednesday or Thursday AND not departing on Wednesday or Thursday - basically they need a room for Thursday night.  Here is what I have that is not working.  I am fairly new to Filemaker and am working with a database that someone else created.  Any help would be appreciated. 

 

filemaker.jpg

Outcomes