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

J_CALENDAR field stores the wrong date

Christoph Aeschlimann

New Member

Posts: 7

6 年 9 个月前 - 6 年 9 个月前 #1747 由 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

Last edit: 6 年 9 个月前 by Christoph Aeschlimann.

Please 登录或注册一个帐号 to join the conversation.

Jamila

User is blocked

Posts: 37

6 年 9 个月前 #1748 由 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 登录或注册一个帐号 to join the conversation.

new

New Member

Posts: 5

6 年 9 个月前 #1749 由 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 登录或注册一个帐号 to join the conversation.

new

New Member

Posts: 5

6 年 9 个月前 #1750 由 new

Replied by new on topic J_CALENDAR field stores the wrong date

Just use regular DATE from sql, it solved my issues.

Please 登录或注册一个帐号 to join the conversation.

Christoph Aeschlimann

New Member

Posts: 7

6 年 9 个月前 #1752 由 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 登录或注册一个帐号 to join the conversation.

Jamila

User is blocked

Posts: 37

6 年 9 个月前 #1753 由 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 登录或注册一个帐号 to join the conversation.

创建页面时间：0.056秒

核心： Kunena 论坛

J_CALENDAR field stores the wrong date

附件：