Transform Map - Dates not being transformed into requested format MM/dd/YYYY

[Felipe Rodr_gu2]

Hello community,

First, I have to let you now that I'm in the process of becoming a BA and I don't have an IT background, so please if you know the answer, try to explain it as simple and clear as possible. THANK YOU FOR YOUR HELP

I'm trying to solve this exercise with a San Diego instance (PDI): https://developer.servicenow.com/dev.do#!/learn/learning-plans/sandiego/new_to_servicenow/app_store_learnv2_importingdata_sandiego_exercise_import_date_enforce_mandatory_and_coalesce

But when testing the date field and checking transform history status, I get an error: 'Complete with errors', and when reviewing the records I encounter these errors:

Upon going back to 'Table Transform Map Import Historic NeedIt Data' and reviewing the format date for 'u_must_have_by' field, I found that has this format date: 'yyyy-MM-dd HH:mm:ss', when modifying it to the one requested in the exercise: MM/dd/yy and then updating, the change it appears to have been successfull but when going back to the same source field and verify if the change was made correctly it goes back to the previous date format (yyyy-MM-dd HH:mm:ss) by itself, inhibiting me from correcting the error. I've tried many times to run transformation anyway, even though it showing the previous format, but I've gotten any positive result.

I believe this is a technical error, what do you people think? #ServicenowSupport

Thank you for your time and help.

Also, I would like to know as well if a placed corretly this Script given in the exercise:   🙂

[Maik Skoddow · Accepted solution]

Hi

First: It is not helpful to mix different issues in one Community question. Therefore I will only answer to your first aspect regarding the data format.

 If I can recognize it correctly you want to select the date format "MM-dd-yyyy", but this format is NOT the same as "MM/dd/yyyy" as each fingle char has a certain meaning/function. That's the reason for having the transform errors.

Instead of selecting one of the OOTB date formats enter into field "Date format" the value "MM/dd/yyyy" and try again.

Maik

[Felipe Rodr_gu2]

Thank you so much for your help, I cannot believe I didn't realize this sooner. 

This is my first question ever, so I will try to use this space correctly. 

It's glad to know that even though I'm learning on my own, there are great people in this community that would take the time to solve these rookie questions.

Have a good one!

[Maik Skoddow]

Thanks for the feedback and glad to hear, that it is working now for you.