# 📅 Methods to Calculate Dates

**URL:** <https://community.glideapps.com/t/methods-to-calculate-dates/63111>\
**Category:** Community Resources\
**Tags:** tutorial\
**Created:** [June 24, 2023, 12:45pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111 "2023-06-24T12:45:19Z")\
**Posts on this page:** 5\
**Page:** 1

<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:** [June 24, 2023, 12:45pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111/1 "2023-06-24T12:45:20Z")

</div>

Dealing with dates is one of the trickiest things to do as an app developer 😵‍💫

Luckily, Glide provides several NoCode options to handle date calculations (they also permit lowcode options, too)!💪

Learn to calculate dates in Glide:

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/ef5ddcc34a48d44cc7c9536d280afc0b98002149.jpeg "Glide: Calculate Dates") ](https://www.youtube.com/watch?v=DkcLP9ZI6V4)

For additional reading, check out this awesome post about various ways to calculate dates:

> [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684):
>
> I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te…

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [June 24, 2023, 2:30pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111/2 "2023-06-24T14:30:36Z")

</div>

Thanks 😊

I have been having “fun” with dates this week.

Getting Openai to consistently read them is proving a challenge for sure.

Just when I think I have cracked it with a clever and detailed prompt it decides to let me down.

All good learning though.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [June 24, 2023, 3:45pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111/3 "2023-06-24T15:45:00Z")

</div>

Awesome thanks Robert!

And yea, I have the exact same data in 4 rows and OpenAI sometimes gives 3 different formatting answers 🤦🏻‍♂️

---

<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:** [June 24, 2023, 6:13pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111/4 "2023-06-24T18:13:14Z")

</div>

That’s why you can’t rely on open AI alone. However, you can use open AI to generate a JavaScript code that will then output a consistent response.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 24, 2023, 11:33pm UTC](https://community.glideapps.com/t/methods-to-calculate-dates/63111/5 "2023-06-24T23:33:53Z")

</div>

I wonder if @Jeremy plans to have something with their newly announced functions to “lock in” responses. That would be great in certain cases, but does eat in to your tokens limit.