Issues with datetime field value upload

[AWmindtree]

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 🙂

[SanfordWhiteman · Accepted solution]

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.