Assign a number to a date
I am trying to assign numbers to dates for a hotel count.... but my formula isn't working. I would have a calculation for each potential date a person would be in a hotel room (across a 2 week span). The calculation would use the arrival and departure dates to assign a value of 1 or 0.
So what i had was...
Case(Hotel_Departure > 10/14/2014 ≥ Hotel_Arrival; 1; 0)
Assuming I arrive on the 13th and stay to the 15th, this should assign a value of 1, but its not. what am i missing???