How to get second tuesday of every month for scheduling the report in servicenow

[Chaitanya Redd1]

Hello Team,

Can anyone help me on the below script. I have to create schedule a report for every month second Tuesday and second Wednesday but it's not working can anyone help me.

var prefixes = ['First', 'Second', 'Third', 'Fourth', 'Fifth'];
    var result;

var gdt = '2019-12-10 00:00:19';
gs.print(gdt);

    var month = gdt.getMonthLocalTime();
    var day = gdt.getDayOfWeek();
    var week = gdt.getDayOfMonthLocalTime();

    var checkWeek = prefixes[0 | week / 7];

   if (day == 2 && (gdt.getDate() >7 && gdt.getDate()<=14)) {
        result = true;
    } else {
        result = false;
    }
    gs.print(result);

[Utpal Dutta1]

Hey Jry,

Please refer to this Community Post: https://community.servicenow.com/community?id=community_question&sys_id=8cee83a1dbdcdbc01dcaf3231f96...

If it helps then please mark my answer Correct and Helpful.

Thanks and Regards:

Utpal Dutta

[Chaitanya Redd1]

It's returning false.

[asifnoor · Accepted solution]

Hi,

Try this code. here are the changes made and its working in bg script.

1. the date/time has to be converted to glidedatetime

2. getDate() returns complete date not days. so corrected that.

var dt = '2019-12-10 00:00:19';
var gdt = new GlideDateTime(dt);
gs.print(gdt);
var day = gdt.getDayOfWeek();
var days = gdt.getDayOfMonthLocalTime();
gs.print(day); 
gs.print(days); 
   if (day == 2 && ((days > 7  && days <=14) || (days >21 && days <=28))) {
        result = true;
    } else {
        result = false;
    }
gs.print(result);

Kindly mark the comment as a correct answer and helpful if it helps to solve your problem.

Regards,
Asif
2020 ServiceNow Community MVP

[Chaitanya Redd1]

I have made chnages to date and time

var dt = '2020-04-07 06:23:19';
var gdt = new GlideDateTime(dt);
gs.print(gdt);
var day = gdt.getDayOfWeek();
var days = gdt.getDayOfMonthLocalTime();
gs.print(day);
gs.print(days);
   if (day == 2 && ((days > 7  && days <=14) || (days >21 && days <=28))) {
        result = true;
    } else {
        result = false;
    }
gs.print(result);

I have got this

*** Script: 2020-04-07 06:23:19
*** Script: 2
*** Script: 7
*** Script: false

can you help me on this because as we can see that 2020-04-07 is first Tuesday of this month and 2020-04-14 is second tuesday but it's taking 2020-04-07 as second tuesday of the month