MMM: Issue adding field which maps to collection_date_start or collection_date_end

[ramdeensarah]

We are unable to map a date field to collection_date_start or collection_date_end. We get an error message - 'You have not selected a date format' even if we had the format set (at the top). This did not prevent us from generating a map, but the map did not include the date fields.

[bowring]

Please supply the data file you were using, thanks.

[ramdeensarah]

Map file saved as a text file
Data used for demo (GitHub does not support CSV files, this will need to be converted)
File demonstrating the mapping between demo data and SESAR fields

[bowring]

Two problems -

1. the date format chosen is invalid since the data has the month first
2. MMM does not (yet) recognize single digit months or days - this can be fixed but the use of single digit months should be avoided.

Thus, if you add "0"s to the dates as in "09/28/05" and choose MM/DD/YY and century 2000, it will work.

[ramdeensarah]

In regards to point 2, there were issues in excel (excel removing leading zeros from the date). In the text formatting, I had to select 'more number formats' then select date, and change the type to be 09/28/05 (see image 1 below). I verified the change in the CSV file (image 2) I was then able to successfully upload the file and add the date (see image 3).

It is worth noting that when I opened the file again in excel, this new formatting was lost.