Leap year calculation

[Hafsa1]

I have a scheduled job below which will send email every 5, 10,15.....years. Here we want to implement leap year too.

Like user joined on 29th feb 2012 which was leap year and he should receive 5 years completion email on 29th feb 2017 but since 2017 was not leap year, hence there was no 29th feb 2017 and no email trigger. Now, we are in 2022 which is not a leap year and email should trigger to almost 70+ employee on 29th feb which will not get trigger as per code below.

We need to trigger email on next available date which is 1st march 2022. How can we adjust below code to calculate leap year too?

***********

function autoEmail() {
var i;

for (i = 5; i < 40; i= i+5) {
var gdt = new GlideDateTime();
gdt.addYearsUTC(-i);
var queryTime = gdt.getDate();
var gr = new GlideRecord('sn_hr_core_profile');
gr.addQuery('user.u_business_unit', 'US');
gr.addQuery('u_joining_date', queryTime);
gr.query();
while(gr.next()) {
if (gr.user.email.toString() == ""){
gs.eventQueue('sn_hr_core.completion_milestone',gr,i,gr.user.manager.toString());
}else{
gs.eventQueue('sn_hr_core.completion_milestone',gr,i,gr.user.toString());
}
gs.info("Employee : "+ gr.user.name + " completed year "+i);
}}}

[Hitoshi Ozawa]

Try adding a check for leap year and adding query condition.

Haven't tested it but something like below.

function autoEmail() {
    var i;

    for (i = 5; i < 40; i = i + 5) {
        var gdt = new GlideDateTime();
        gdt.addYearsUTC(-i);
        var month = gdt.getMonthLocalTime();
        var date = gdt.getDayOfMonthLocalTime();
        var year = gdt.getYearLocalTime();

        var queryTime = gdt.getDate();
        var gr = new GlideRecord('sn_hr_core_profile');
        gr.addQuery('user.u_business_unit', 'US');
        //gr.addQuery('u_joining_date', queryTime);
        if (month == 2 && date == 28 && isLeapYear(year)) {
            var nDate = gdt.addDaysLocalTime(1);
			var queryString = "u_joingnON" + queryTime + "@javascript:gs.dateGenerate('" + queryTime + "','start')@javascript:gs.dateGenerate('" + queryTime + "','end')^ORsys_created_onON" + nDate + "@javascript:gs.dateGenerate('" + nDate + "','start')@javascript:gs.dateGenerate('" + nDate + "','end')";
			gr.addEncodedQuery('u_joining_date', queryString);
        } else {
            gr.addQuery('u_joining_date', queryTime);
        }
        gr.query();
        while (gr.next()) {
            if (gr.user.email.toString() == "") {
                gs.eventQueue('sn_hr_core.completion_milestone', gr, i, gr.user.manager.toString());
            } else {
                gs.eventQueue('sn_hr_core.completion_milestone', gr, i, gr.user.toString());
            }
            gs.info("Employee : " + gr.user.name + " completed year " + i);
        }
    }
}

[Hafsa1]

will it send 10 yrs completion email on 1st march if employee joining date was on 29th march 2012? Because in 2022 29th feb doesn't exists

[Hitoshi Ozawa]

I've set to send it on Feb. 28th. I thought it would be better to send notification before rather than after.

if (month == 2 && date == 28 && isLeapYear(year)) {

To send it on March 1st, change as follows.

        if (month == 3 && date == 1 && isLeapYear(year)) {
            var nDate = gdt.addDaysLocalTime(-1);

[Hafsa1]

is there any function for "isLeapYear(year)"?