Default date element time to 00:00:00

[jo-ka]

Hello.
I'm using Joomla 3.8.13 with Fabrik 3.8.1

I'm having an issue here:

On a certain form I need to have a date element which stores the date on the database, with the time set always to 00:00:00.

I've tried all the options, but the date is always stored as, for today's example (2018-10-11 18:38:34)

What I need is to, no meter what time it is, the time value is always 00:00:00, so the expected behavior is to have (2018-10-11 00:00:00)

The strangest thing is that I've already a field like this on other form, and it's working, and I can't replicate this, even though I've set the fields exactly the same way.

What can I ever made on the other field to have this working as expected that I'm not able to do on this one?

Thanks in advance.

 

[jo-ka]

Well, I ended up doing this, although the other field doesn't have this configured... But, for now I think it solves the problem.
Thanks guys.

 

[cheesegrits]

What are you other settings?

Give me screen shots of Formatting & Time and Date Formats.

-- hugh

 

[jo-ka]

OK, here's some screenshots. These are from the new element. The other element has exactly the same settings.