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.

[Ankur Bawiskar]

Hi,

Can you share how it looks in import set table since you are doing some split etc?

Regards
Ankur

[Anubhav Ritolia]

They are sending date as 2020-04-03 12:25:35.344.

So we are just splitting to remove that milli-second part. And as the field in Tmport set table is string, it is same as 2020-04-03 12:25:35.344.

[Ankur Bawiskar]

Hi Anubhav,

did you check by adding log whether you are getting the correct value after doing the split etc

Did you check for which values it is behaving in this way

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Can you use onBefore transform script instead of field map and use this script

// your string manipulation here
// then do this

var time = new GlideDateTime(datTime);
target.<fieldName> = time;

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi,

this worked for me well in onBefore transform script

target.setDisplayValue('u_sample_date_time', source.u_time_string);

Incoming value: 2020-04-03 12:25:35

Target Value: Set correctly

So you also try to handle using onBefore transform script; Also ensure the source field is of type string and not date/time

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur