# Issue with Dates ans Hours

**URL:** <https://community.glideapps.com/t/issue-with-dates-ans-hours/78059>\
**Category:** Ask for Help\
**Created:** [November 20, 2024, 12:13pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059 "2024-11-20T12:13:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo\_Novas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulo_novas/32/73277_2.png) [@Paulo\_Novas](https://community.glideapps.com/u/Paulo_Novas)\
**Post date:** [November 20, 2024, 12:13pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/1 "2024-11-20T12:13:18Z")

</div>

Hi! need help, trying set periods of the day in a table like from 8:00 to 12:00 - 12:00 16:00 …

Trying to use IF Then, but in the before or afther there is no custom so i can get an hour but not the ones before

sorry would be easy but i did not find

regards

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 20, 2024, 3:20pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/2 "2024-11-20T15:20:48Z")

</div>

Did you mean that you want something like that:

- If `Time` **is before** 12:00 → `"Morning"`.
- If `Time` **is before** 16:00 → `"Afternoon"`.
- If `Time` **is before** 20:00 → `"Evening"`.
- Else → `"Night"`?

---

<div class="post-metadata">

**Author:** ![Paulo\_Novas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulo_novas/32/73277_2.png) [@Paulo\_Novas](https://community.glideapps.com/u/Paulo_Novas)\
**Post date:** [November 20, 2024, 4:13pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/3 "2024-11-20T16:13:14Z")

</div>

Hi MaximeBaker,

Yes would solve my problem

Regards

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 20, 2024, 4:21pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/4 "2024-11-20T16:21:17Z")

</div>

First, create a Math column to get only the hours:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/5737544432edd13eeb6e8f15c963a4ede84fff7e.png)

Then, create your if-then-else column like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf3930aa5457263f056ebba951e8163f001518d4.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b75ba87b9334c34a5c8eb1fbea232a3f3be42b7e.png)

---

<div class="post-metadata">

**Author:** ![Paulo\_Novas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulo_novas/32/73277_2.png) [@Paulo\_Novas](https://community.glideapps.com/u/Paulo_Novas)\
**Post date:** [November 20, 2024, 4:34pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/5 "2024-11-20T16:34:45Z")

</div>

Hi Max,

Great many thanks! It is working now

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 20, 2024, 4:35pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/6 "2024-11-20T16:35:14Z")

</div>

My pleasure !!!

---

<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 27, 2024, 4:35pm UTC](https://community.glideapps.com/t/issue-with-dates-ans-hours/78059/7 "2024-11-27T16:35:39Z")

</div>

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