Date plugin

[merlino68]

joomla 3.8.3 php 7
I have a date field where when I insert a date in the field es. 02/01/2018 in the database it is registered 01/01/2018, always one day less.
The field is not calculated but a simple date plugin
the value in the form and in the list is instead correct 02/01/2018

 

[troester]

The Fabrik date element is date-time and per default in the database stored as UTC (always in the SQL format YYYY-mm-dd).
So if you insert time =00:00 and your timezone is MEZ (Italy?) UTC will be a day less 23:00

 

[cheesegrits]

And just to finish off that explanation ...

When Fabrik renders your dates, it automatically re-applies the time zone offset (as set in J! options).

You can configure your date element to "Store as local", but unless you have a specific need to do this, we don't recommend it. It's generally "best practise" to store all dates/times in UTC, and apply TZ offsets when displaying them. This makes the data much more portable.

-- hugh

 

[merlino68]

Ok thanks for the clarification