SOLVED

Re: Issues with datetime field value upload

Go to solution
AWmindtree
Level 4

Issues with datetime field value upload

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Issues with datetime field value upload

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.

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Issues with datetime field value upload

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.