- 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-12-2025 12:52 AM
Hi @Ankur Bawiskar,
Thank you so much for all your help. It is working now.
Can you please confirm do I need to do Event parm1 contains Recipient checkbox is True and send to event creator checkbox is true as well.
Regards,
Nivedita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2025 01:02 AM
Glad to know.
Please mark my response as correct and close the thread.
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-12-2025 01:03 AM
Send to event creator can be False.
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 05:43 AM
Hi @Ankur Bawiskar,
I have executed that code and it is not checking if condition.
Please find below screenshot :
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:48 AM
I shared the script which worked for me along with output and screeenshots
Seems you don't have users having birthday on 11th Feb
Did you check that?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader