Scheduled Report by every other week on Monday.

[d-aizawa]

Hi.

I want to create a feature to email reports on the 1st and 3rd Mondays 00:00, but I don't know how.

Help me!

[Hitoshi Ozawa · Accepted solution]

Hi d-aizawa,

In the Scheduled Reports ("Reports" > "Scheduled Reports"), check the "Conditional" checkbox.

In the Condition, enter the following script:

var gdt = new GlideDateTime();
var dayOfWeek = gdt.getDayOfWeekLocalTime();
var dayOfMonth = gdt.getDayOfMonthLocalTime();
var weekOfMonth = Math.ceil(dayOfMonth/7);

gs.info(dayOfWeek);
gs.info(weekOfMonth);
var answer = false;
if (weekOfMonth == 1 || weekOfMonth == 3 && dayOfWeek == 1) {
  answer = true;
}
answer;

[Hitoshi Ozawa]