Datetime Adding Extra Hour Post-upload

Anonymous
Not applicable

Datetime Adding Extra Hour Post-upload

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?
Tags (1)
5 REPLIES 5
Anonymous
Not applicable

Re: Datetime Adding Extra Hour Post-upload

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
Not applicable

Re: Datetime Adding Extra Hour Post-upload

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
Not applicable

Re: Datetime Adding Extra Hour Post-upload

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

Re: Datetime Adding Extra Hour Post-upload

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
Not applicable

Re: Datetime Adding Extra Hour Post-upload

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?