Hello,
You could use a formula to check if the room is free "today":
Where the formula "free today" is:
IF(AND(DATETIME_DIFF(From,TODAY(),'days')<0,DATETIME_DIFF(TODAY(),To,'days')>0),"Yes",
IF(AND(DATETIME_DIFF(From,TODAY(),'days')>0,DATETIME_DIFF(TODAY(),To,'days')<0),"Yes",
IF(AND(DATETIME_DIFF(From,TODAY(),'days')<0,DATETIME_DIFF(TODAY(),To,'days')<=0),"No",
IF(AND(DATETIME_DIFF(From,TODAY(),'days')<=0,DATETIME_DIFF(TODAY(),To,'days')<0),"No"
))))
Using the formula "Today()" may not be a good option since it's being computed all the time and can hence have some consequences on performances.
This being said, I guess that you want to compare reservation dates with customer required dates, meaning that you will not need to use the "Today()" function.
Regards,
Pascal