Script condition Flow designer

[Natanael]

Hello everyone, I have a workflow that runs every day to check whether it's an employee's birthday or not. For this, I created a custom field called 'Birthdate,' but I need to create a conditional script that selects only the day and month. Currently, it evaluates the condition based on the current date's year, which is causing an error. If anyone can help me, I would appreciate it. Thanks!!

[SanjivMeher]

It is definitely easier to do using a scheduled job than a flow designer.

If you are using a flow designer, you may need to create an action, which will query the user table, get users with same month and day. then trigger an event. You can refer the script provided by Sanuja Kulkarni and use in the flow action.

[Natanael]

I thought about doing it through scheduled jobs, but how can I ensure that the notification/email is sent only to those who are celebrating their birthday on that day?

[SanjivMeher · Accepted solution]

So basically your scheduled job will run at 6 everyday.

In the scheduled job, query all the users which has birthday on the same day and month.

Once you find that, for all those user trigger event. And the event should then trigger the notification.

So basically you need to create a event registry and a notification which should trigger based on event.

Here is an article, how you create event and notification

https://tech.forums.softwareag.com/t/servicenow-email-notification-via-event/237437