Method Community

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?

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

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

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