× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

J_CALENDAR field stores the wrong date

6 years 9 months ago - 6 years 9 months ago #1747 by Christoph Aeschlimann
J_CALENDAR field stores the wrong date was created by Christoph Aeschlimann
Hi

I do have a problem with the J_CALENDAR field. When I enter a date and store the record. One day will be substracted from the date.

Here a sample:


Datum1is entered as 19.02.2018


After saving the Datum1 is set to 2018-02-18

I do have the Problem in Front- and Backend and withy any dateformat I have tested now.

Any ideas?

Thanks Chrigu
Attachments:
Last edit: 6 years 9 months ago by Christoph Aeschlimann.

Please Log in or Create an account to join the conversation.

6 years 9 months ago #1748 by Jamila
Replied by Jamila on topic J_CALENDAR field stores the wrong date
Hi Christoph,

I just created a component with J_Calendar and for me it saves the date I select. Have you changed anything in the field configurations?

Best regards,
Jamila Cisse

Please Log in or Create an account to join the conversation.

6 years 9 months ago #1749 by new
Replied by new on topic J_CALENDAR field stores the wrong date
I have simular problem, it saves only todays date, it doesn't save any other

Please Log in or Create an account to join the conversation.

6 years 9 months ago #1750 by new
Replied by new on topic J_CALENDAR field stores the wrong date
Just use regular DATE from sql, it solved my issues.

Please Log in or Create an account to join the conversation.

6 years 9 months ago #1752 by Christoph Aeschlimann
Replied by Christoph Aeschlimann on topic J_CALENDAR field stores the wrong date
The regular DATE from sql can not be formated as %d.%m.%Y.

The solution is to set the PHP and the Joomla timezone to UTC. This solves the problem. It is not perfect, because we are not in UTC timezone. But it is working for me now.

Chrigu
The following user(s) said Thank You: Jamila

Please Log in or Create an account to join the conversation.

6 years 9 months ago #1753 by Jamila
Replied by Jamila on topic J_CALENDAR field stores the wrong date
Hi Christoph,

I researched this a bit further. This issue is related to the way Joomla stores dates. You can read more about it here: issues.joomla.org/tracker/joomla-cms/5954

Thank you for letting us know how you solved the issue.

Best regards,
Jamila Cisse

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.

Learn More