Need assistance with script?

[piyushsain]

Hi,

Use below script 

var date= new GlideDateTime(source.u_last_contact);
date = date.getByFormat('yyyy-mm-dd HH:mm:ss');

[Community Alums]

Hi @piyushsain , How to handle two different format which are coming from source?

[piyushsain]

Hi @Community Alums 

Whatever may be the source format if you use above code it will change the format to the required format

[Harsh_Deep]

Hello @Community Alums 

Use this -

answer = (function transformEntry(source) {
    var gdt = new GlideDateTime();
    var parsedDate = new Date(source.u_last_contact);
    if (!isNaN(parsedDate.getTime())) {
        // Format the date as 'yyyy-MM-dd HH:mm:ss'
        var formattedDate = parsedDate.toISOString().replace(/T/, ' ').replace(/\..+/, '');
        return formattedDate;
    }
    else{
        return source.u_last_contact;
    }
})(source);

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.