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

**URL:** <https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872>\
**Category:** Ask for Help\
**Tags:** date-math\
**Created:** [November 13, 2024, 9:29am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872 "2024-11-13T09:29:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben164](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben164/32/54019_2.png) [@Ben164](https://community.glideapps.com/u/Ben164)\
**Post date:** [November 13, 2024, 9:29am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872/1 "2024-11-13T09:29:32Z")

</div>

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?

 ![Screenshot 2024-11-13 at 09.22.50](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b64245444be2670cd2a4adff3d9a83b6ad2d5425.png)  
 ![Screenshot 2024-11-13 at 09.23.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/911b265f58427105728907edf90bcb4cb016f8b0.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 13, 2024, 9:37am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872/2 "2024-11-13T09:37:10Z")

</div>

Use “if check in date is within today”

You don’t need the math column.

---

<div class="post-metadata">

**Author:** ![Ben164](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben164/32/54019_2.png) [@Ben164](https://community.glideapps.com/u/Ben164)\
**Post date:** [November 13, 2024, 9:51am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872/3 "2024-11-13T09:51:20Z")

</div>

Genius! Thank you so much!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 20, 2024, 9:51am UTC](https://community.glideapps.com/t/filtering-a-check-in-date-to-show-only-todays-bookings/77872/4 "2024-11-20T09:51:34Z")

</div>

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