Current date and time in workspace

sakshi18 · ‎03-21-2025

Greetings,

Element used:

Workspace: BCM Workspace

Table: Event

Code written in : UI Action (ClosedComplete), Workspace Client Script field.

We have a requirement where upon clicking on a button the 'closed on' field should get populated with current date and time in BCM workspace.

But when we used 'var dateNow = new Date();' we received a different type of date format which cannot be used in the field i.e.., 'Fri Mar 21 2025 16:15:58 GMT+0530 (India Standard Time)'

Below is the code that we have written so far.

function onClick(g_form) {

var dateNow = new Date();

alert(dateNow);

var title = getMessage('Accept policy');

var message = getMessage("Are you sure you want to accept this policy?");

g_modal.confirm(title, message, function(confirmed) {

if (confirmed) {

alert(dateNow);

g_form.setValue('closed_on', dateNow);

g_form.setValue('state', '30');

g_form.save();

}

});

return false;

}

We are unable to fetch date and set it in closed on field. When the setValue (Closed_on) line is commented, then the code runs fine.

Requesting for quick help as this is on priority.

ref: screenshot

Thank you,

Sakshi

Ankur Bawiskar · ‎03-21-2025

@sakshi18

why are you using JSON.parse() when you are not returning JSON from script include

that line is breaking the script

try this

function onClick(g_form) {
    var title = getMessage('Accept policy');
    var message = getMessage("Are you sure you want to accept this policy?");
    g_modal.confirm(title, message, function(confirmed) {
        if (confirmed) {
            var ga = new GlideAjax('sn_recovery.Crisis_Event_Client_Utils');
            ga.addParam('sysparm_name', 'getDatetime');
            ga.getXMLAnswer(function(answer) {
                alert('5 hi');
                alert('7 - result: ' + answer);
                g_form.setValue('closed_on', answer);
                g_form.setValue('state', '30');
                g_form.save();
            });
        }
    });
    return false;
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

sakshi18 · ‎03-21-2025

@Ankur Bawiskar

the result i got in alert is yyyy/mm/dd format

and i want it in dd/mm/yyyy format

closed_on field is also taking values in dd/mm/yyyy format
so i need to change it

sakshi18 · ‎03-21-2025

@Ankur Bawiskar yes, this worked
i'll check for the correct reply and accept it as solution

Thank you so much for helping