question Display only the date from a datetime field in Developer forum

Display only the date from a datetime field

ceraulo — Mon, 14 Dec 2020 09:27:05 GMT

Hello!

I have a notification running on the sc_task table. I want to display the due date field from the RITM to the notification.
I can do this by dot walk. However, I only want to display the date section (bold part from the sample) of the value.

Due date: 2020-12-15 16:00:00 PST

Is this possible?

Thanks!

Re: Display only the date from a datetime field

Narsing1 — Mon, 14 Dec 2020 09:37:22 GMT

Hi,

On the Notification Email Script, you can take like this.

var gdt_duedate = new GlideDateTime(current.<duedate variable>);
var gd_duedate = new GlideDate();
gd_duedate.setValue(gdt_duedate);

var onlydate = gd_duedate.getByFormat("MM/dd/yyyy").toString();

Please mark it as correct answer if your issue resolves.

Thanks,

Narsing

Re: Display only the date from a datetime field

Ankur Bawiskar — Mon, 14 Dec 2020 09:37:22 GMT

@ceraulo

You will require to handle this via email script

Then include that email script in your notification body using ${mail_script:mailScriptName}

(function runMailScript(current, template, email, email_action, event) {

    // Add your code here

var gdt = new GlideDateTime(current.request_item.due_date);

var date = gdt.getLocalDate();

template.print('Date'+ date);

})(current, template, email, email_action, event);

Regards
Ankur