Form-maker problem inserting date into Mysql table

Completed

Colin Jamieson

• August 19, 2021 18:18

I've got a from with a standard date field.  The form is mapped to a mysql table containing a date column. The form filed stores the date as dd-mm-yyyy, but mysql requires the date in yyyy-mm-dd format.  I could map the date field to a text column and then convert to a date  column after but it would be better to insert the data in the right way immediately after submission of the form. Is there a way to do this?

0

• 

  Zhanna Khachatryan

  • November 09, 2021 19:05
  • Edited

  Hi Colin, 

  Thanks for the idea. 

  It is possible with current functionality. You can just change date filed format from form maker's edit date field options, please see the screenshot https://nimb.ws/UJCZQo.

   

  0

Please sign in to leave a comment.