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?

 

[SoniaShridhar13]

@Alon Grod  

Try

(function executeRule(current, previous /null when async/) {

var gd = new GlideDate();

current.'your fieldname' = gd.getByFormat('YYYY-MM-DD');

})(current, previous);

[Alon Grod]

@SoniaShridhar13 i need DD-MMM-YYYY

[SoniaShridhar13]

var gdt = new GlideDate(source.your_date_field); var dt = gdt.getByFormat("dd/MM/yyyy"); return dt;

[Alon Grod]

it will return in the system 04-AUG-2022? @SoniaShridhar13 

[SoniaShridhar13]

Yes