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:
For additional reading, check out this awesome post about various ways to calculate dates:
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.
Awesome thanks Robert!
And yea, I have the exact same data in 4 rows and OpenAI sometimes gives 3 different formatting answers
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.