Scheduler to send email as a birthday reminder

Need to create a birthday reminder email scheduler.
The Date of Birth is in a User table. While creating a scheduler where to add the condition to check if the user’s birthday is tomorrow and will send an email.

Hi @girish.kamble,

Welcome to the group!

You could run a Task (Automation - Scheduled Tasks) daily and then if necessary you may need to run a Pipe to call the Tadabase Date Utilities pipe to get tomorrows date. I’m sure there are a number of other ways you could do this too but this would work.

Another way, which might be easier, is to to create a field in the table which is a dateformula and have this as the day before the birthday. Then the scheduler can just check if it’s equal to that date.

1 Like