# Date-Time Math question

**URL:** <https://community.glideapps.com/t/date-time-math-question/17796>\
**Category:** Ask for Help\
**Created:** [October 31, 2020, 4:31pm UTC](https://community.glideapps.com/t/date-time-math-question/17796 "2020-10-31T16:31:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![benmitchell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benmitchell/32/13820_2.png) [@benmitchell](https://community.glideapps.com/u/benmitchell)\
**Post date:** [October 31, 2020, 4:31pm UTC](https://community.glideapps.com/t/date-time-math-question/17796/1 "2020-10-31T16:31:21Z")

</div>

Hi, I’m looking for help - is it possible to use any of the native math functions to separate the date or time from a date/time column ?

---

<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:** [October 31, 2020, 5:20pm UTC](https://community.glideapps.com/t/date-time-math-question/17796/2 "2020-10-31T17:20:02Z")

</div>

Yes, just create create a math column, type in a value, such as ‘X’, then replace it with the date column you want to use. Then set the the format to be date only or time only.

---

<div class="post-metadata">

**Author:** ![benmitchell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benmitchell/32/13820_2.png) [@benmitchell](https://community.glideapps.com/u/benmitchell)\
**Post date:** [October 31, 2020, 8:18pm UTC](https://community.glideapps.com/t/date-time-math-question/17796/3 "2020-10-31T20:18:20Z")

</div>

Thanks for the reply Jeff. The problem I’m facing is relating two of these columns in different sheets as they seem to retain the date/time part and don’t match.  
Any workarounds without using gsheets?

---

<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:** [October 31, 2020, 9:20pm UTC](https://community.glideapps.com/t/date-time-math-question/17796/4 "2020-10-31T21:20:37Z")

</div>

Create a template columns of the date or math column and use that for your relation. Templates will “lock in” the formatting you set on the date/math column and not use the underlying date value anymore.

---

<div class="post-metadata">

**Author:** ![benmitchell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benmitchell/32/13820_2.png) [@benmitchell](https://community.glideapps.com/u/benmitchell)\
**Post date:** [November 1, 2020, 10:22am UTC](https://community.glideapps.com/t/date-time-math-question/17796/5 "2020-11-01T10:22:18Z")

</div>

Great stuff! cheers