Current date and time in workspace

[sakshi18]

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

[sakshi18]

I am getting this in the alert

and i want dd:mm:yyyy hh:mm:ss format

also the 'Closed_on' date is staying empty even after update

[Ankur Bawiskar]

@sakshi18 

the date format is correct. what's your date/format for your profile or in preferences?

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

[sakshi18]

@Ankur Bawiskar 

i want the result to be in DD/MM/YYY HH:MM:SS format

in my preference

[Ankur Bawiskar]

@sakshi18 

why?

your date time format is DD-MM-YYYY then why to get it in other format?

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

[Ankur Bawiskar]

@sakshi18 

try this

getDatetime: function() {
        var gdt = new GlideDateTime();
        gs.addInfoMessage('Hi');
        return gdt.getDisplayValue();
    },

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