We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

How to set display value on date if the value is a string?

e_wilber
Tera Guru

I'm not sure how to better phrase this question.

 

I am trying to use isInSchedule and it's always showing false, which according to https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1001223, it's because I am passing a date into the GlideDateTime.

 

Since this is a script include that's just getting the date passed via this format, how do I set display value to get it in the correct format? startTime is receiving the date in format 10/30/2023 17:00:00.


var assignedTo = this.getParameter('sysparm_assigned_to');

var startTime = this.getParameter('sysparm_start'); // format: 10/30/2023 17:00:00
var glide = new GlideRecord('cmn_schedule');
var personalSchedule = new global.FSMMobileUtil().getUserSchedule(assignedTo);

 

var checkdate = new GlideDateTime(startTime);
checkdate.setDisplayValue(checkDate);
var sched = new GlideSchedule(glide.sys_id);

gs.log('is this in schedule? : ' + sched.isInSchedule(checkdate)); // ALWAYs returns false

2 REPLIES 2

Ankur Bawiskar
Tera Patron

@e_wilber 

try this

var assignedTo = this.getParameter('sysparm_assigned_to');

var startTime = this.getParameter('sysparm_start'); // format: 10/30/2023 17:00:00
var personalSchedule = new global.FSMMobileUtil().getUserSchedule(assignedTo);


var checkdate = new GlideDateTime(startTime);
checkdate.setDisplayValue(startTime, 'MM/dd/yyyy HH:mm:ss'); // use the format while setting
var sched = new GlideSchedule('scheduleSysId'); // pass schedule sysId here

gs.log('is this in schedule? : ' + sched.isInSchedule(checkdate)); // ALWAYs returns false

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

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

I did try this and it's always returning false regardless of whether or it it's actually within their schedule.

 

I am printing out the discovered schedule and assigned to along with the date and all the values are correct, it's just failing.