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.

[AnubhavRitolia · Accepted solution]

Hi All,

Issue was solve just by changing the Date/Time Format in Field mapping from yyyy-mm-dd hh:mm:ss to yyyy-mm-dd HH:mm:ss.

Just changed hh to HH format.

[Ankur Bawiskar]

Great!  It looks like you marked your own response as the correct answer, which may be confusing to others that read this later.

if you think there is any response that helped you please mark that as helpful & accepted so that others can be benefited by this

Regards
Ankur