Remove Time stamp from the updated field

[shabbir9]

Hi Team,

i am using sys_updated_on field in notification but time stamp is coming when i am using ${sys_updated_on} like this "2023-08-22 12:42:51" i want to remove time from this i have created mail script for this but its not working sharing the script can anyone help me in the script 

var updated = current.sys_updated_on;

var dateRE = /^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}.*\n/;

template.print(updated.replace(dateRE, ''));

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

[Shruti]

var updated = current.sys_updated_on;

updated = updated.split(" ");

var date = updated[0];

template.print(date);

[Najmuddin Mohd]

Hello @shabbir9 ,

You can use OOB GlideDate() functionality.

var updatedValue = current.getValue('sys_updated_on');
var newUpdatedValue = new GlideDate('updatedValue');
template.print(newUpdatedValue);

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[Vaibhav_Nikam]

Hi @shabbir9   
  var date = current.sys_updated_on.split(" ");    //split the date with the 1 empty space

        template.print(date[0]);

[Ankur Bawiskar · Accepted solution]

@shabbir9 

you can use this in email script

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

    // Add your code here
var gdt = new GlideDateTime(current.sys_updated_on);
var date = gdt.getLocalDate();
template.print(date);
})(current, template, email, email_action, event);

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