Hello,
today we faced a problem with the Retool database, because of the datetime-fields.
In our apps we use insert queries in which we set the value for the created field of the data record the following way:
{{ moment().tz('UTC'+1).format('DD.MM.YYYY HH:mm')}}
This always worked fine for months, up until today, when suddenly the queries failed to insert new records.
Now we get the following error message in the output of the query:
returning * - date/time field value out of range: "13.12.2023 17:49:29"
Have there been any updates to how the datetime fields in the Retool database work? Why do all of our queries in our apps report errors due to the datetime field value being out of range all of a sudden?
Thanks in advance.