# Recording Late for employees that clocked in

**URL:** <https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027>\
**Category:** Ask for Help\
**Created:** [March 27, 2025, 9:32pm UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027 "2025-03-27T21:32:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![HR\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hr_manager/32/86452_2.png) [@HR\_Manager](https://community.glideapps.com/u/HR_Manager)\
**Post date:** [March 27, 2025, 9:32pm UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027/1 "2025-03-27T21:32:58Z")

</div>

I am trying to only identify employees that are late on the current day. I am using a if-then-else column to do this but it keeps selecting the previous day. Please see pictures you can disregard the duplicate columns as I have been try different formats unless you think it matters.

Thanks for any assistance

 ![glide 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0cb557c04eb9217a36271cd903b19ea738ea0f6.jpeg)  
 ![glide 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/9/890333da71650833fe6c17d181e0896d9e5e738e.png)

---

<div class="post-metadata">

**Author:** ![HR\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hr_manager/32/86452_2.png) [@HR\_Manager](https://community.glideapps.com/u/HR_Manager)\
**Post date:** [March 27, 2025, 9:35pm UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027/2 "2025-03-27T21:35:48Z")

</div>

@Robert_Petitto I am using your clock in template

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 28, 2025, 12:23am UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027/3 "2025-03-28T00:23:05Z")

</div>

Can you show me why is the Late Cutoff Time seemingly different for different rows?

---

<div class="post-metadata">

**Author:** ![HR\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hr_manager/32/86452_2.png) [@HR\_Manager](https://community.glideapps.com/u/HR_Manager)\
**Post date:** [March 28, 2025, 12:37am UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027/4 "2025-03-28T00:37:45Z")

</div>

It’s based on their shift schedule or time. Each can be different

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 29, 2025, 4:41am UTC](https://community.glideapps.com/t/recording-late-for-employees-that-clocked-in/81027/5 "2025-03-29T04:41:02Z")

</div>

![CleanShot 2025-03-29 at 11.40.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e00a5329b26d189b9a7f8cac71e116f19bbec4c.png)

Why do you have this as “equals” though? Wouldn’t it be “not equal” since you don’t want to check the data for dates that are not today?
