# Date/Time math

**URL:** <https://community.glideapps.com/t/date-time-math/41902>\
**Category:** Ask for Help\
**Created:** [May 12, 2022, 6:02pm UTC](https://community.glideapps.com/t/date-time-math/41902 "2022-05-12T18:02:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 12, 2022, 6:02pm UTC](https://community.glideapps.com/t/date-time-math/41902/1 "2022-05-12T18:02:42Z")

</div>

I have a “Date” and I want to ‘add’ time to it.

For example the Due Date (from a Date Picker) is May 13 and I want to add either 7 AM or 12 PM or 5 PM to the Due Date and create a “Due Date/Time”.

I can’t get ‘Date Math’ to work.

Thanks

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 12, 2022, 6:04pm UTC](https://community.glideapps.com/t/date-time-math/41902/2 "2022-05-12T18:04:43Z")

</div>

To add time, start with a date in a date time column. Add a math column and add a value in days (eg. +1 = 1 day, + 0.5 = +12 hours).

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 12, 2022, 9:43pm UTC](https://community.glideapps.com/t/date-time-math/41902/3 "2022-05-12T21:43:37Z")

</div>

Using the “% of the day” in the date addition did the trick.

---

<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:** [May 13, 2022, 9:44pm UTC](https://community.glideapps.com/t/date-time-math/41902/4 "2022-05-13T21:44:18Z")

</div>

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