# Compare a future date if \< 5:00PM
**URL:** https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301
**Category:** Ask for Help
**Created:** [June 24, 2021, 5:01am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301 "2021-06-24T05:01:50Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [June 24, 2021, 5:01am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/1 "2021-06-24T05:01:50Z")
Hoping this can be achieved via Glide Tables. I have the following columns:
> `lastBookingTime` is a date in the future (Jul 10th, 2.30PM)
> `lastBooking+1hr` is the date above + 1 hour
I am trying to do a simple IF-ELSE as follows;
IF `lastBooking+1hr` \< 5:00 PM (Jul 10th, 5.00PM)
**How do I set 5:00 PM to July 10th a date in the future to do the comparison?**
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [June 24, 2021, 5:26am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/2 "2021-06-24T05:26:38Z")
I think you can use math column to add hours using decimals,
because if 1 is a day, then 1 hour is a twenty-fourth of a day.
Try, i’m not in front my pc.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [June 24, 2021, 5:38am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/3 "2021-06-24T05:38:35Z")
I get that…the question is more, how do I set a date/Time of `Jul 10th, 2:30PM` to be `Jul 10th, 5:00PM`
all the dates are dynamic, I want to set 5:00PM to all of them
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [June 24, 2021, 6:07am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/4 "2021-06-24T06:07:01Z")
Ok, so if I understand, for example if the date/time is Jul 11th, 1:15PM the new date must be anyway Jul 11th, 5:00 PM ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 24, 2021, 6:10am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/5 "2021-06-24T06:10:13Z")
This is adapted from something that @ThinhDinh gave me recently. It could possibly be simplified…
```auto
Date-HOUR(Date)/24-MINUTE(Date)/1440-SECOND(Date)/86400+(17/24)
```
The first part of the formula finds midnight on the date in question, and then we add 17 hours (17/24) to get 5pm.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [June 24, 2021, 6:44am UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/7 "2021-06-24T06:44:02Z")
that worked! - Thanks Darren!
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/compare-a-future-date-if-5-00pm/28301/8 "2024-01-17T16:51:42Z")