# 📅 Guide on Dates & Times

**URL:** <https://community.glideapps.com/t/guide-on-dates-times/70381>\
**Category:** Community Resources\
**Created:** [February 1, 2024, 6:37pm UTC](https://community.glideapps.com/t/guide-on-dates-times/70381 "2024-02-01T18:37:32Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [February 2, 2024, 1:53am UTC](https://community.glideapps.com/t/guide-on-dates-times/70381/21 "2024-02-02T01:53:13Z")

</div>

Yes, the delay occurs approximately 2-3 minutes, as mentioned by @nathanaelb. This is an old issue that can be addressed with tolerance communicated to the user (using a slight mathematical formula to subtract 5 minutes from the deadline). Of course, the condition is to use the ‘extra-sync mode’ option. However, there’s a small note that can be a bit unsettling: ‘All syncs in extra mode count as updates, even if no data has changed.’ 😜

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [February 5, 2024, 2:27am UTC](https://community.glideapps.com/t/guide-on-dates-times/70381/22 "2024-02-05T02:27:58Z")

</div>

Yes @Jeff_Hager, using the API is the most accurate way to get the remaining time duration, although this will consume updates based on the number of clicks. Meanwhile, fetching the ‘now’ data is heavily dependent on the synchronization timing between Glide and the spreadsheet, which won’t update without user activity in the app (unless you choose extra sync options). The middle ground is implementing two conditions, relying on the user’s device time and considering the condition of the ‘Now’ from the spreadsheet, which generally has some delay. While waiting for a resolution regarding the ‘Now’ from Glide.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 2, 2025, 1:14pm UTC](https://community.glideapps.com/t/guide-on-dates-times/70381/23 "2025-04-02T13:14:46Z")

</div>

> [@nathanaelb](#):
>
> First day of the month
> 
> ```auto
> date-DAY(date)+1
> 
> ```

If you need midnight on the first day of the month, the above can be expanded as follows:

```auto
Now
-DAY(Now)+1
-HOUR(Now)/24
-MINUTE(Now)/1440
-SECOND(Now)/86400

```

[Previous page](https://community.glideapps.com/t/guide-on-dates-times/70381.md?page=1)