Method:Classic General Q&A

Re: Incorrect date format message after importing data from EXCEL

Method_Michael — Thu, 18 Nov 2010 20:17:14 GMT

Hi Gregory,

I tested importing a CSV file with dates on my end using the format I suggested and it worked. If possible can you email me a sample CSV file of what you are trying to import, so I can test it on our end. You can send it to m.melo@methodintegration.com.

Michael

Re: Incorrect date format message after importing data from EXCEL

Gregory — Thu, 18 Nov 2010 19:15:53 GMT

Yeh, I thought of that and tried it......didn't work. Got the same irritating error message. Got a back-up suggestion?

Re: Incorrect date format message after importing data from EXCEL

Method_Michael — Wed, 17 Nov 2010 22:00:55 GMT

Gregory,

Try the following format 2010-Nov-17 12:00:00 PM . A good way to figure out the proper formatting for fields when trying to import data is to first export data from the table you are going to import into. For example to come up with this date format I used the Import / Export feature to export the CreatedBy field from the Activity table into a CSV file.

Hope this helps.

Michael

Incorrect date format message after importing data from EXCEL

Gregory — Mon, 15 Nov 2010 19:15:45 GMT

I am trying to import data into the Activity table, including data for the CreatedDate field. No matter how I try to format the datetime data in the CreatedDate column in my CSV file, the data is imported without error, but when I go into the Activity screen in method to look at it, I get an "invalid data format" error popup. I can click out of the popup and then view the Activity screen, but this is very annoying.

How can I format the datetime data in my CSV import file so that data I import for the CreatedDate field does not cause this annoying popup error to occur?