Filtering A Check In Date to Show Only Today's Bookings

Morning,

I have been reading a number of previous threads but cannot find a method to approach the below, can anyone help please?

I am building a Hotel Booking System and would like to filter the Check in Date of a booking to show only bookings which are in for today. I.e show a table with just today’s bookings in it.

I have a Check In Column (Date & Time) and a Math = Today column (computed) but they are not in the same data formats for a common output, and will not work for IF THEN ELSE (example: IF the booking equals today’s date then say ‘Today’).

Any ideas how I would get these into a common field type to make this work please?


Use “if check in date is within today”

You don’t need the math column.

Genius! Thank you so much!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.