# Problem With Unix Lookup

**URL:** https://community.glideapps.com/t/problem-with-unix-lookup/77677
**Category:** Ask for Help
**Created:** [November 6, 2024, 5:10pm UTC](https://community.glideapps.com/t/problem-with-unix-lookup/77677 "2024-11-06T17:10:09Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 6, 2024, 6:11pm UTC](https://community.glideapps.com/t/problem-with-unix-lookup/77677/8 "2024-11-06T18:11:13Z")

</div>

Well, without being provided any screenshots of the math involved, I went ahead and did some digging and found the following post.

I don’t know if it’s still the same setup, but assuming it is, my best guess is that time is factoring in somewhere on one of the dates.

> [@List All Dates Between Start And End Date](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667):
>
> I Need A Way To List All Dates Between Start Date And End Date To Eliminate Double Booking Someone For The Same Spot During That Time Anyone Know How To Do This

Rather than dealing with the 1/1/1970 unix date, I would just `TRUNC(Date)` the start and end dates. The result is the google style of date numbers, but essentially it’s the same concept, simplifies the setup, and rules out any issues with underlying times.

---

_[View the full topic](https://community.glideapps.com/t/problem-with-unix-lookup/77677)._