Date picker submitting date one month early + time issue

Wappler Version : 3.9.7
Operating System : Windows 10
Server Model: Node.js
Database Type: MySQL
Hosting Type: Heroku

Expected behavior

I have an input in a form on my page, set to be a Date Picker with the “Time Picker” option checked.
Using the server connect form to insert into the database field (Type: Datetime) I would expect that if I put 07/05/2021 (DD-MM-YYYY) and 12:00 as the time, the database entry would reflect something similar

Actual behavior

Putting in those values like so:
image1

This is how it looks in the database:
image2

It’s most likely something silly I have done, but after checking over it again I can’t seem to figure it out!
Any help would be appreciated.

Community Page
Last updated: