Regarding property bookings. We have a check-in & check-out field, both with time fields included.
Typical check-in starts at 3:00pm and check-out is 11:00am.
DATETIME_DIFF to see booking length in ‘Days’ shows 1 less that, in these cases (clearly it is counting days in 24 hour blocks, and 3:00pm-11:00am is < 24 hours).
Is there an easy workaround I’m missing, to use date fields w/ time fields included, yet calculate booking length in ONLY # days?
Let me know if this makes sense.