1292:Incorrect date value when trying to add a special with expiry date

Hi, guys,

not a question of life and death here, but it seems interesting to me:

when trying to add a new special with an expiry date, I recieve this error log:

Request URI: /admin/specials.php?page=1&action=update
#1 trigger_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/site/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/site/public_html/admin/specials.php:103]
--> PHP Fatal error: 1292:Incorrect date value: '20292301' for column 'expires_date' at row 1 :: UPDATE specials
SET specials_new_products_price = '13.0833',
specials_last_modified = now(),
expires_date = '20292301',
specials_date_available = '0001-01-01'
WHERE specials_id = 263 ==> (as called by) /home/site/public_html/zoe/specials.php on line 103 <== in /home/site/public_html/includes/classes/db/mysql/query_factory.php on line 171.

file specials.php is unchanged (1.5.6c)
table specials seems to be unchanged too...

I can easily run on specials without expiry date, but does anybody know, what is triggering this problem?

what value are you putting in the expiry date field when you create the special?

Tried multiple dates - mainly 2026 to 2028. Not happening all the time, though

What is the *exact value* that goes into the expiry date field? You should be entering MM/DD/YYYY assuming you have made no other changes.
So for Dec. 31, 2026, enter 12/31/2026.

So, for example, I use a value like this: 01.11.2029

I don´t add these dates manually - they are added by the table on the right side of the row