So I have a simple form that saves data to a Retool DB. The form contains two "Date Time" and "Date" fields, nothening to fancy. Only one "Date Time" field is required, the other fields are optional. The fields don't have a default value, and use the default formatting. The two "Date Time" fields have the "manage time zone" toggle selected and both use "Local time" for display and value. Now when all the date fields are populated I get no error. When one or more date fields are left blank/empty I get the following errors depending on the type of date field.
invalid input syntax for type date
invalid input syntax for type timestamp with time zone
I'm scratching my head on this one but I think it has something to do with the Retool DB. Maybe the date fields in the DB are configured wrong. IDK