Date field register date

I have a table that one of the fields is type date. In my insert.asp page when I type the date for example so 10/07/2017 or 2017-07-12 does not save in the MySQL database.

The error that is shown is this:

  

Error: [MySQL] [ODBC 3.51 Driver] [mysqld-5.7.13-log] Incorrect date value: '' for column 'start_dir' at row 1

I've created a function in the HTML code:

<%
Function InverteDataMySql(data_inicio)
if not isdate(data_inicio) then exit function
if instr(data_inicio, " ") > 0 then
hora  = split(data_inicio, " ")(1)
end if
InverteDataMySql = year(cdate(data_inicio)) & "-" & month(cdate(data_inicio)) & "-" & day(cdate(data_inicio))
if hora <> "" then InverteDataMySql = InverteDataMySql & " " & hora
End Function 
%>

I call the function here on the insert.asp page:

<tr>
    <td>Data Inicio:</td>
    <td>
     <input name="FormDataInicio" size="10" maxlength="80" value="<%=Response.Write(InverteDataMySql())%>"/>
    </td>
</tr>

But it does not work.

Everything has been resolved in SQL itself using STR_TO_DATE

The code looks like this:

 "INSERT INTO tb_registros_para_controle(nome_livro, nome_autor, nome_editora, data_inicio, " 
sql = sql & " data_termino, data_paralisacao, "
sql = sql & " segunda_feira, terca_feira, quarta_feira, quinta_feira, "
sql = sql & " sexta_feira, sabado, domingo, observacao) VALUES ( " 
sql = sql & "'" & Request.Form("FormNomeLivro")                  & "', "
sql = sql & "'" & Request.Form("FormNomeAutor")                  & "', "
sql = sql & "'" & Request.Form("FormNomeEditora")                & "', "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataInicio")     &"','%d/%m/%Y')" & ", "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataTermino")    &"','%d/%m/%Y')" & ", " 
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataParalisacao")&"','%d/%m/%Y')" & ", "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataSegunda")    &"','%d/%m/%Y')" & ", "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataTerca")      &"','%d/%m/%Y')" & ", " 
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataQuarta")     &"','%d/%m/%Y')" & ", "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataQuinta")     &"','%d/%m/%Y')" & ", "
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataSexta")      &"','%d/%m/%Y')" & ", " 
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataSabado")     &"','%d/%m/%Y')" & ", " 
sql = sql & "STR_TO_DATE('" & Request.Form("FormDataDomingo")    &"','%d/%m/%Y')" & ", "
sql = sql & "'" & Request.Form("FormNomeObservacao") & "' " 
sql = sql & ")"