Problem saving empty date fields to Retool DB

Welcome to the forum @Jeff76

I have to dodge this particular pothole quite often.

You have to send a null back to the database if the date or time components are not populated. This is the easiest way:

I did not give the job_date the same treatment as start_time and end_time as it is a required field.

3 Likes