Import_asset_csv_to_matrix.php metadata date format

Squiz Matrix Support
1

I am using the import_asset_csv_to_matrix.php script and need to set a metadata date field. However, I cannot figure out the format that it is expecting, so that date always gets set incorrectly. Here is the format I am giving it:

2010-12-23 00:00:00

What format is it expecting when setting a Metadata date field?

2

Anyone? Really need to figure this out. I cannot find it documented anywhere.

3

Update. The date does seem to get set, and it looks correct before I get locks:

 

 

But when getting the locks, the date is incorrect and doesn't seem to respect the year:

 

 

Ideas on what could be going wrong?

4

Update:

 

I figured it out. The metadata date field had a Min year default set to 2016, so 2010 wasn't allowed. Don't I feel silly now. :)