- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 04:00 AM
Hi,
I have to send birthday notification to employee. I have written schedule job script and date of birth is type as date field. I have tested that script and I'm able to get birthday, birthday day, birthday month value, it seems it is having issue while checking if condition.
Please find below script and correct that :
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 11:46 PM
to verify this in HR scope.
Create fix script in HR Core scope and see if the script works
Also don't use gs.log(), it won't work in scoped app, use gs.info()
var gr = new GlideRecord("sn_hr_core_profile");
gr.addQuery("user.active=true^date_of_birthISNOTEMPTY");
gr.query();
while (gr.next()) {
var bdate = gr.date_of_birth.toString();
var to_date = new GlideDateTime(); // current day's date
var bday = bdate.split("-")[2]; // birthday date
var bmonth = bdate.split("-")[1]; // birthday month
gs.info('birthday is' + bdate);
gs.info('today date is' + to_date);
gs.info('birthday day is' + bday);
gs.info('birthday month is' + bmonth);
// Adjust month comparison to account for zero-based index
if ((to_date.getMonthLocalTime()) == parseInt(bmonth) && to_date.getDayOfMonthLocalTime() == bday) {
c++;
gs.info('count is here' + c);
gs.info("Hi, it's the user's birthday! for " + gr.user.name);
gs.eventQueue("sn_hr_core.birthday.notification", gr, gr.user.name.toString(), gr.user.email.toString());
}
}
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 04:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 04:43 AM
Hello @niveditakumari , You can compare with help of GlideDate API too, but why don't you write an encoded query and do this easily like below:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 05:01 AM
Hi @Nishant8,
It is printing for all user. I want to send notification to user whose birthday is today.
Can you please help me to correct that.
Regards,
Nivedita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 05:18 AM
Hello @niveditakumari , I did a quick test in my PDI and can see users, whose b'day is today, printed fine. PFA screenshots. not sure whether i'm missing something unknowingly.
Regards,
Nishant