Update target with a null value if the source is null from transform map

[Community Alums]

Update target with a null value if the source is null from transform map with out using 'Copy Empty Fields'

I have used below script but it is not working, could I get some help here please

answer = (function transformEntry(source,target) {

//var gdt = new GlideDateTime(source.u_last_day);
//return gdt.getValue();
//if (source.u_last_day == '') {
if (source.u_last_day.nil()){
target.u_last_day == '';
}

})(source);

[Ankur Bawiskar]

@Community Alums 

try this

target.setValue('u_last_day','');

[Community Alums]

Sorry, this didn't work too

[Ankur Bawiskar]

@Community Alums 

did you check by clearing some other field?

[Community Alums]

Yes,  the script is working for other string fields. Not working only on date fields.

[Kirby R]

Can you check if that field is mandatory on table level? Any import logs you found? Maybe there's data policy or something.