Format of Date field in transform map

[Alon Grod]

Hi,

In my xlsx file the Date filed is written: 04-AUG-2022

Is there any way to change the date format in the transform map so it will know how to get this format from the xlsx file?

 

[Alon Grod]

Im not getting the date field.

 

xlsx file:

 

[Alon Grod]

@SoniaShridhar13 

[SoniaShridhar13]

Have you tried like below-

var sd = new GlideDate();
sd.setValue( source.<date_attribute>)
var formatedDate=sd.getByFormat('D-M-yyyy');
return formatedDate

[Kevin Paul]

Hi,

This is out of topic! I tried to post a question in the developer forum, but it is still waiting for some approval. How can I get it approved? and post the question?

[Sonu Parab]

Hi @Alon Grod ,
Have a look at this post.
https://www.servicenow.com/community/developer-forum/date-format-transform-maps/m-p/1559129