1

Adding a date to the news_from_date to a new product using the calendar returns to this format: dd/mm/yyyy

but if I mass import (via magmi) a DB the value in magento has been changed to something like "11/30/00-1" which is obviously wrong.

Improve this question

1 Answer 1

Reset to default
4

When saving a product, all dates attributes are processed before saving. They are converted from the format corresponding to your admin locale to the standard mysql format (YYYY-mm-dd).
You can try to supply your import with the dates in this format.
For example: June 25th 2013 will be 2013-06-25

Improve this answer
5
  • Hi Marius! with the dash or backslash like YYYY/MM/DD ?
    – Gabriele
    Commented Jun 25, 2013 at 11:03
  • I would say with a dash. But if it doesn't work, try with a slash.
    – Marius ♦
    Commented Jun 25, 2013 at 11:13
  • dash was good ;)
    – Gabriele
    Commented Jun 26, 2013 at 0:48
  • @Marius awesome.this I was looking for.you're Magento Jedi :)
    – Andhi Irawan
    Commented Aug 4, 2016 at 4:15
  • Got to add, it's really misleading of Magento that the product export had the format yyyy/mm/dd. The moment I saw this and changed the import to a dash it worked perfectly. thanks for the post!
    – Jaimie Dijstra
    Commented Jan 20, 2020 at 12:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.