question Re: Schedule Entry Start/End Date in Developer forum

Schedule Entry Start/End Date

solonxu — Thu, 21 Jan 2016 20:22:58 GMT

Hi, Community,

I am trying to get the start/end date in current year, for example, I have a schedule set as:

If I call schedule_entry.start_date_time, it returns '2014-10-21', which I actually want 2016-10-21.

Does anyone know if there is any oob function I can use to get the updated data? Or I have to calculate through custom script?

Any suggestion would be appreciated.

Re: Schedule Entry Start/End Date

dhasselquist — Thu, 21 Jan 2016 20:53:56 GMT

Solon,

If you want the same date (day and month) but with the current year, I don't know that there is an out of the box function to do that. The only way I'm familiar is with plain javascript.

Using "var gDate = new GlideDate();" for example would return "2016-01-21", the current date. If you wanted to take, say, "2014-04-13" and make it "2016-04-13" that would require some scripting.

Can you explain a little more about what you're trying to do?

Re: Schedule Entry Start/End Date

solonxu — Thu, 21 Jan 2016 21:06:03 GMT

Thank you Dylan.

I setup a yearly-repeating schedule entry, like the screenshot I attached. If I submit a form today (created_on: 2016-01-20), I would like to compare this 'Created_on' date with the schedule entry (should be 2016-01-21 in this year). However if I use schedule_entry.start_date_time it returns '2014-01-21".

I am wondering if there is a way I can get this year's date in this schedule without scripting.

Re: Schedule Entry Start/End Date

dhasselquist — Thu, 21 Jan 2016 22:05:32 GMT

I haven't really used schedules much out of the box, so forgive me if I'm misunderstanding.

What I am trying to figure out is why you need to do a comparison on the year of the day specified in the schedule.

Re: Schedule Entry Start/End Date

solonxu — Fri, 22 Jan 2016 03:32:44 GMT

OK, for example, we want all ticket with Start Date (u_start_date) in following time window to be marked as 'Emergency':

Dec 25 - Jan 3rd

July 4 - July 7

Sep 1 - Sep 3

System admin (with no scripting knowledge) should have the ability to add/edit time window entry, what would you suggest to do?

Thanks.

Re: Schedule Entry Start/End Date

Nana5 — Fri, 22 Jan 2016 14:05:07 GMT

Hi Solon,

I think u can increase the year.

For catalog i use to increase 30 days based on current day using below business rule.Please have a look it may helps for u.

function onBefore(current, previous) {

//This function will be automatically called when this rule is processed.

var anActualDate = new GlideDateTime();

anActualDate.setDisplayValue(current.request_item.variable_pool.u_employee_leaving.getDisplayValue());

var datePlusOne = anActualDate.getNumericValue();

datePlusOne += (1000*60*60*840);

current.due_date.setDateNumericValue(datePlusOne);

}

Re: Schedule Entry Start/End Date

dhasselquist — Fri, 22 Jan 2016 18:40:12 GMT

My understanding of schedules is that they are used with/for SLA's and inactivity monitors. I don't think this is necessarily the best way to approach what you are trying to solve.

I'm just throwing stuff out here, others can weigh in, but I would do this kind of thing via data lookup rules or business rule. In this specific circumstance you could do it without scripting, by creating an on insert business rule. You could then specify in the condition builder if the Opened (opened_at) or created was on or between two date times. However, you would run into the same problem of having to maintain these dates by modifying them to reflect the current year, or scripting it.

This is my "back of the envelope" idea, but if I HAD to write a script, I would do something similar to the below and put it in an insert business rule.

//First we need the list of day/month that will be specicifed. Make sure day and month are two digits separated by a "-".

var highPriority = ["12-25","12-26","12-27","12-28","12-29","12-30",

"12-31","01-01","01-02","01-03","07-04","07-05",

"07-06", "07-07","08-01","08-02","08-03","01-22"];

//dayMonth will return "dd-mm" for the current date. For example, today it would be "01-22"

var today = new GlideDate().toString();

var dayMonth = today.substring(today.length() - 5);

//Check the contents of highPriority array to see if dayMonth matches

for (i=0;i<highPriority.length;i++){

if (highPriority[i] == dayMonth)

{

//Found a match, set the field and exit the loop

current.urgency = 1;

break;

}

In my example I set urgency to be high, but this would be whatever you needed.

Can anyone weigh in on this? I feel like there might/should be a way to do this OOTB.