Date/Time format is changing will importing through Transform Map

[Anubhav Ritolia]

Hi All,

When I am trying to import value for Date/Time field, and it the hours is 12, it is automatically converting it to 00. But it is working properly when it is 13Hr or even 23Hr.

For example, If I import 2020-03-05 12:50:40 in system it comes as 2020-03-05 00:50:40.

But, If I import 2020-03-05 13:50:40 in system it comes as 2020-03-05 13:50:40 properly. 

Also there is no AM or PM mentioned. What can be the issues?

This is happening for all Date/Time fields present in my table.

[Dhruv Gupta1]

One quick suggestion while importing make the field in import set as of type string. And the transform it to date time field then it should behave based on the configuration like 12 hr or 24 hr format

[Anubhav Ritolia]

Hi Dhruv,

Yes the field is string type only in source table and transforming it same way. you can refer the screenshot I have attached.

[Ankur Bawiskar]

Hi,

please share what format you are selecting and the field map or any script you are using?

Thanks
Ankur

[Anubhav Ritolia]

Hi All,

Please find the Field mapping below: