Showing results for 
Search instead for 
Did you mean: 

Invalid input datetime format of value Invalid date magento 2

1 x Certified

Invalid input datetime format of value Invalid date magento 2


  1. Log in to Admin
  2. Go to Products -> Categories
  3. Input any text in "Category Name" field
  4. Click "Schedule Design Update" -> Input any numbers in " Schedule Update From/To" fields
  5. Click "Save"

Actual result: blank page, error in log

"Invalid input datetime format of value 'Invalid date'";i:1;s:5854:"#0 /var/www/kozhemyakin/store_216ce/vendor/magento/zendframework1/library/Zend/Filter.php(114): Magento\Framework\Stdlib\DateTime\Filter\DateTime->filter('Invalid date')
Expected resullt: "Invalid input date format" message appears

Also it the same when you try to save product 

save_product_datetime issue.png


It because there are some attribute like custom_design_from or custom_design_to, news_from_date or news_to_date get value="Invalid date" you can inspect source to view:


<input class="admin__control-text _has-datepicker" type="text" data-bind="
    hasFocus: focused,
    datepicker: { storage: shiftedValue, options: options },
    valueUpdate: valueUpdate,
    attr: {
        value: shiftedValue,
        name: inputName,
        placeholder: placeholder,
        'aria-describedby': noticeId,
        disabled: disabled
    }" id="dp1497002098538" value="Invalid date" name="product[custom_design_from]" placeholder="" aria-describedby="notice-BQKPEC7">



- Go to table eav_attribute find attribute_code with custom_design_from or custom_design_to, news_from_date or news_to_date then you will get attribute id

- Now open table catalog_product_entity_datetime search by attribute_id you will see datetime value wrong, please correct it or delete.


- This way apply for mass product and it often wrong if value = 0000-00-00 00:00:00

- Or you can select other date in datetime select in product detail if issue only for one product.

Finally you need run reindex: bin/magento indexer:reindex

Hope for help.


Crystal-Techs Solution:
Frequent Visitor

Re: Invalid input datetime format of value Invalid date magento 2

hello i am facing same problem in Magento 2.1.7

this is cache issue please use different browser and check again its work

products add in cart successfully