Need help for one of Date time field

Are Kaveri
Tera Contributor

‎02-01-2024 06:43 AM

Hi,

 

I need help for one the requirement.

we have created date and updated date on my custom table.

i need to pull date from date time field.

 

can someone help me how to pull date from created (which is date time field)

The below is the script for Business rule we have 

r.setStringParameterNoEscape('start_date', current.getValue("sys_created_on"));
r.setStringParameterNoEscape('end_date',  current.getValue("sys_updated_on"));

 

i need to get value as Date.

 

 

Please help me with the script.

 

0 Helpfuls
  • 179 Views
1 REPLY 1

Bert_c1
Kilo Patron

‎02-01-2024 10:08 AM - edited ‎02-01-2024 10:11 AM

Hi @Are Kaveri,

 

Here's an example of getting a Date value from the two "Date/Time" fields in a script.

 

 

var inc = new GlideRecord('incident');
inc.addQuery('active', true);
inc.setLimit(10);
inc.query();
while (inc.next()) {
   var sdate = new GlideDateTime(inc.sys_created_on);
   var edate = new GlideDateTime(inc.sys_updated_on);
   var start_date = sdate.getDate();      // Get the date value
   var end_date = edate.getDate();       // Get the date value
   gs.info("Incident: " + inc.number + ", start_date: " + start_date + ", end_date: " + end_date + ".");
}

 

See: GlideDateTime API

 

 

0 Helpfuls