Importing Dates into existing MM profiles

[gayle]

Any helpful tips - other than retyping all my dates!

I have all my dates in an Access database - I then export that data into an Excel spreadsheet.

I can then break apart the dates by using "Text to Columns" and then use "Concatenate" to put them back in the order that MM likes them - but any single digit month or date loses the preceding zero.

So for example 03/01/2012  which MM wants to be 20120301  becomes 201231. 

Help!  Thoughts?

[Radishworks]

Make sure to include dashes in your dates for MM to understand them.  I.e. "2013-01-22" is the correct format.

[gayle]

Hmmm... but I just imported a test excel csv file where I had typed in 20120102 and MM converted it to 01/02/2012.  The format of the cell was "general" if that makes a difference as to why it worked. 

[TARSAR]

If you're working with Access and/or excel, treating the data type as text as opposed to numerical data usually works better when combining (concatenating) data fields.

[gayle]

Thanks all - I figured out how to fix my problem!