× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

DB-field date contains 0000-00-00 but «30. November -0001» is displayed

More
2 years 1 month ago #6580 by crimle
I am using an event database with some fields like «sport», «eventtitle», «startdate», «enddate» and «location.
There are events that last one day and there are events that last a range of two or more days.
In my catalogue Template I have
{joodb field|startdate} - {joodb field|enddate}
and this works fine for events with a valid date in the the «startdate» and «enddate» fields.

Single day events where the field «enddate» was left blank, are displayed like «30. November -0001». Example:

SVSE Verband - 134. GL-Sitzung SVSE
20. April 2022 - 30. November -0001


To be precise, the field «enddate» is not empty but contains a value like «0000-00-00». But why on earth is this value changed to «30. November -0001»???

Thank you and kind regards
Chris

Please Log in to join the conversation.

Moderators: Dirkjoest