Datetime Adding Extra Hour Post-upload

Forum|Forum|11 years ago
June 4, 2014
5 replies
1263 views

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?

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

A

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

A

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.

A

Anonymous

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

A

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?

A

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?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded