AnsweredAssumed Answered

Assign a number to a date

Question asked by StaceyManderscheid on Aug 11, 2014
Latest reply on Aug 11, 2014 by philmodjunk

Title

Assign a number to a date

Post


     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??? 

Outcomes