Issues with datetime field value upload | Community
Skip to main content
AWmindtree
AWmindtree
Level 4
May 14, 2021
Solved

Issues with datetime field value upload

  • May 14, 2021
  • 1 reply
  • 1718 views

Hi All,

We are using Bulk Import API to upload our csv files to Marketo. A strange thing we noticed, that while importing Date Time fields, we are seeing a 1 hour extra in the field value. We have set an offset value to -5 and this issue is intermittent, for some leads only. Some leads are imported fine with correct value for the same countries.
 Any suggestions what could be the issue?

Thanks in Advance 🙂

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

You should be importing times in UTC (Z): 2021-06-01T12:34:56Z.

 

Offsets are not recommended because they force you to use a table of Daylight Saving time transitions.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
May 14, 2021

You should be importing times in UTC (Z): 2021-06-01T12:34:56Z.

 

Offsets are not recommended because they force you to use a table of Daylight Saving time transitions.

    Terms & ConditionsAccessibility statement

    Loading footer...