📅 Methods to Calculate Dates

[Robert_Petitto]

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:

Glide: Calculate Dates

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

Fun with Dates

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…

[Rosewebstudio]

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.

[Joe_Gabriele]

Awesome thanks Robert!

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

[Robert_Petitto]

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.

[ThinhDinh]

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.