I want set upcoming birthdays of users in dashboard

[Abishek V]

In existing user table i added date of birth for users and now i have to create dashboard for upcoming birthday list and every year it need to show how can i acheive this?

[OlaN · Accepted solution]

Sure thing!

Write a business rule, as below:

And as script, write something like this:

(function executeRule(current, previous /*null when async*/) {

	var nextBirthday = new GlideDateTime(current.getValue('u_birth_date'));  // change field name to your custom field name
	while(nextBirthday.before(new GlideDateTime())){
		nextBirthday.addYears(1);
	}
	current.setValue('u_next_birthday', nextBirthday);  // change field name to your custom field name

})(current, previous);

[Abishek V]

thanks olaN,

but i used this method directly called script include function name in reports field  for upcoming bdays anniversary in dashboard and its working fine

function upAnniversary() {

    var upanniversary = [];

    var today = new GlideDate();

    var format = today.getByFormat('MM');

    var userGR = new GlideRecord('sys_user');

    userGR.addActiveQuery();

    userGR.addQuery('u_dobISNOTEMPTY');

    userGR.query();

    while (userGR.next()) {

        var DOJ = userGR.u_doj.toString();

        var anniversary = DOJ.split("-");

        DOJ = anniversary[1] + '-' + anniversary[2];

        if (format == anniversary[1]) {

            upanniversary.push(userGR.getValue('name'));

            //gs.print(userGR.name);

        }

    }

    return upanniversary;

}

[OlaN]

Don't forget, you will also need to create a Flow or scheduled job, that runs yearly, and updates the next birthday date on all existing records.