Datetime Adding Extra Hour Post-upload

[Anonymous]

Hello,

I'm experiencing an issue where Marketo adds an extra hour onto a datetime value after data is uploaded.

Sample data: 6/4/2014 16:00
What it looks like in the upload preview: 6/4/2014 16:00
What it looks like in lead info post-upload: 6/4/2014 5:00 PM

Any idea as to what's going on here? Could it be a time zone or daylight saving time issue?

[Anonymous]

Sounds like a UTC time offset issue. Please check to see if your timezone settings are correct, as described in this help aritcle:

https://community.marketo.com/MarketoArticle?id=kA050000000L8k8CAC

[Anonymous]

Hi Murtza,

Thanks for your suggestion. Can you go into a bit more detail regarding Marketo's backend process for handling datetimes? Is there a conversion process that I'm unaware of, and if so, can you explain the parameters involved? My initial thought was that Marketo parses datetimes in the exact form in which they are uploaded, irrespective of account time zone.

[Anonymous]

I am not sure. I am going to get the right person to look at this thread. 

[Anonymous]

Hi Wyatt,

If you import a file containing a time attribute with the value 2014-06-04 16:00:00, the value will be stored as 4:00 PM (Central Time) on 6/4/2014. If your Marketo instance logging is configured to be in Eastern Time and you view the value in the UI, it will be displayed as 5:00 PM (Eastern Time) on 6/4/2014.

I have follow-up question so we can provide more detail. What import mode are you using for this?

[Anonymous]

I'm uploading a CSV to a list. Can you tell me why Marketo processes (date)times in CT and converts them according to user time zone instead of just processing them in that time zone?