Transform map: How to change date/time format on field map?

[Ridhima_1]

Hi,

In our system, SNOW sends computer last scan date to ServiceNow everyday through Transform map. We see on SNOW the last scan date is in the format 5/3/2024 3:55:50 PM but in ServiceNow Staging table the last scan date is in format 2024-05-03 03:55:50

AM/PM is missing in the staging table record. So it seems SNOW is sending the data in 12h format but ServiceNow is excluding AM/PM from the end and not identifying whether it's 03 PM or 15. Please assist here as changing format in SNOW is not possible.

Field map date format is yyyy-MM-dd HH:mm:ss

Thanks in advance!

Regards

[Kieran Anson]

5/3/2024 3:55:50 PM date time format would be symbolised as dd/MM/yyyy HH:mm:ss a the addition of the 'a' will allow SN to understand whether it's AM or PM

[Ridhima_1]

Hi,
It is still not working the timestamps in the staging table are all between 01:00 and 12:59, so it seems they are still in the 12h format. We should have something also between 00:00 - 00:59 and 13:00 - 23:59.

Maybe because the Last scan field on staging table is string type not date/time, also we are not able to change the type. Can you suggest here if we need to write a script for this? 

Thanks

[Kieran Anson]

Apologies the HH shouldn't be capitalised

[Ridhima_1]

Hi,

It still didn't work. Is it that we have to write a script to check if it's PM then add 12 hours? Can you please help here.

Regards