# App not updating database

**URL:** https://community.glideapps.com/t/app-not-updating-database/73211
**Category:** Ask for Help
**Tags:** data-sync
**Created:** [May 9, 2024, 4:58am UTC](https://community.glideapps.com/t/app-not-updating-database/73211 "2024-05-09T04:58:20Z")
**Posts on this page:** 1
**Showing post:** 9

<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: [May 9, 2024, 1:41pm UTC](https://community.glideapps.com/t/app-not-updating-database/73211/9 "2024-05-09T13:41:48Z")

</div>

This post has reference to two other posts that I think will be very useful. Start there and let me know if you have questions.

> [@Simple timesheet](https://community.glideapps.com/t/simple-timesheet/72973/4):
>
> Here are two posts from the same thread that may be useful. The rest of it would probably involve some math to calculate a duration between each start and end date time, and then a rollup to add all of durations for the day.

Once you have a normal start date column created from the math column, then you can add the appropriate value in another math column to get the end date. Date math in glide is based on days. To add a day, to a date you simply add one. If you want to add hours or minutes, then you need add the corresponding decimal value. Each hour is ~0.0416666 (or 1/24). Each minute is ~0.00069444 (or 1/1440).

In the end you will have a start and end date that are true dates, so it will be easy to sort, filter, and query based on those dates instead of having to convert to integers.

---

_[View the full topic](https://community.glideapps.com/t/app-not-updating-database/73211)._