Kind regards,
Sourabh

This unfortunately isn’t working – I have the same need as well. Not sure how to put in a negative duration (if that is even possible).

I tried following code in background script.

var todaysDate = new GlideDateTime();
todaysDate.setDisplayValue(gs.nowDateTime());

gs.print(“todaysDate display value : ” + todaysDate);

My Timezone is US/Eastern but, this is still returning output in GMT format asour instance is in GMT format.

Could you please let me know if i am missing anything?

Thanks & Regards,
Amisha Parekh

I had this issue, this is what I can up with…

// Date Time variable taken from my form
var dateTime = g_form.getValue(‘u_date_and_time’);
// a duration number (minutes in this case)
var duration = g_form.getIntValue(‘u_duration’);

// Split up the Date and Time for manipulation and reordering
var dateSplit = dateTime.split(” “)[0];
var timeSplit = dateTime.split(” “)[1];

var date = dateSplit.split(“-“)[0];
var month = dateSplit.split(“-“)[1];
var year = dateSplit.split(“-“)[2];

var hours = parseInt(timeSplit.split(“:”)[0]);
var minutes = timeSplit.split(“:”)[1];
var seconds = timeSplit.split(“:”)[2];

// Reorder & combine dateTime and create the endDateTime
dateTime = (year + “-” + month + “-” + date + ” ” + hours + “:” + minutes + “:” + seconds);
// Where I added minutes on…
endDateTime = (year + “-” + month + “-” + date + ” ” + hours + “:” + minutes + duration + “:” + seconds);

// This allows you full flexibility with regards to changing any parts of the time or date and changing the order

In your case you could just do…

date = date – 1;

You may want to check that date isn’t 1 and if it is reduce the month by 1 and work out which month it is for the days then set the date to the last day of the previous month.
Not an ideal solution but it should help.

I haven’t tried this specifically, but you might try ‘sched.subtract’ instead.

Thanks for this article which has already helped me on several occasions.

Do you know of any way to perform a substract instead of an add?

I tried with:

var timeToAdd = -86400; // negative time
durToAdd = new GlideDuration(timeToAdd*1000);
var newDateTime = sched.add(currentDateTime, durToAdd, ”);

But sched.add just returns the same value as currentDateTime.

Use case: I have a task where I know the due date, its duration, and a schedule, and would like to calculate the start date accordingly.

Thanks in advance for your reply,
David

Unless ServiceNow has it documented somewhere (and I don’t think they do in this case) I don’t know how you would know unless you had used it before. A close examination of my code above would have told you the data type of the information being passed in but I can see how that might be overlooked. At least now you’ll know for next time. I would contact ServiceNow and request that they document GlideSchedule so it’s available in the future.

It worked.

One question: Is there any way to check the method in a package because we faced issue because we didnt know what was the input parameter data type as well as output parameter.

Thanks in advance.

I’d be surprised if this worked in any release, let alone Calgary. The problem isn’t with the code I’ve supplied above, but you do have an issue with the date your passing from the client. The date is being passed as a string to your back-end function because that’s how the date values are formatted client-side. The ‘add’ method requires a ‘glideDateTime’ object, not a string. You’ll have to convert the string being passed into your function before using ‘sched.add’. Something like this should work better to replace the ‘var firstDT = this.getParameter(‘sysparm_fdt’); //First Date-Time Field’ line in your script above.

var firstDT = new GlideDateTime();
firstDT.setDisplayValue(this.getParameter(‘sysparm_fdt’));