No need for case, and your syntax is in error.
Hotel_Departure > Date ( 10 ; 14 ; 2014 ) And Hotel_Arrival < GetAsDate ( "10/14/2014" )
Will return the value 1 if 10/14/2014 is in the specified range of dates from arrival to departure.
Note that in a FileMaker calculation 10/14/2014 is interpreted as 10 divided by 14 divided by 2014 so one of the two functions that I've used is needed to get FileMaker to treat 10 / 14 / 2014 as a date.
But using a constant for the date seems a very impractical calculation. A date field or Get ( CurrentDate ) would seem a better option.
Thanks! I'll test this out! I don't want to use current date because I need this over a selected time frame...for each day. Not just a snapshot of one day (CurrentDate). Or do I misunderstand your suggestion?
The point that I am making is that 10/14/2014 will always be the date that you are comparing to the dates in the arrival and departure date fields. That seems unlikely to be useful to you and constantly redefining the calculation to use a different date seems very impractical. Thus it would seem a better idea to replace that constant October 14th date with the date from a field or function.