How to calculate the Date field in between InDate and OutDate
I have below guest house highlighted field reg no, Room no, InDate, out date and I want to calculate the Date field in between InDate and outDate because I want to check the Room status any particular date. so How to calculate the Date field.
Below are the sample Data.
Eg: If I Select Date 15-09-2017 so room no 110 Status Should Show OCCUPIED and if select 17-07-2017 than room Status should be UNOCCUPIED.