How to change time format in Transform map?

[Ridhima_1]

Hi,

Greetings for the day!
In our system, SNOW sends computer last scan date to ServiceNow everyday through Transform map but there was no data from afternoon even though sent in evening. We see on SNOW the last scan date is in the format MM/DD/YY HH:MM:SS AM/PM but in ServiceNow Staging table the last scan date is in format MM/DD/YY HH:MM:SS

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 thinks they are all in 24h format. Please assist here as changing format in SNOW is not possible.

Thanks in advance!

Regards

[Sohail Khilji]

Hi @Ridhima_1 ,

Date/Time fields are stored in 24-hour format, it's the display preference that can make it show am/pm. In staging table usually see in 24hr format but later when it move to actual target table it may show am/pm based on peference selected.

[Ridhima_1]

Hi,

In staging table it's showing 12 hour format which should be 24 hours format, can you please assist here.
We have tried field map date format as yyyy-MM-dd HH:mm:ss and yyyy-MM-dd HH:mm:ss a but they didn't work.

Regards

[Community Alums]

Hi @Ridhima_1 ,

Please refer to this thread : https://www.servicenow.com/community/developer-forum/format-of-date-field-in-transform-map/m-p/24621...

[Ridhima_1]

Hi,

This didn't help. In staging table it's showing 12 hour format which should be 24 hours format.

Regards