Hi Team,
Can anyone tell me how to calculate the anniversary date in an organization
Req: Should send mail automatically when an employee completed one year in an organization. I need the Query conditions to calculate that
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Sreevarshini-P ,
In that case you can use a condition like,
Day(@dateOfJoining) EQUAL TO Day(GetDate())
AND
Month(@dateOfJoining) EQUAL TO Month(GetDate())
In the above screenshot, you can use @dateOfJoining instead of date of birth
Hi @Sreevarshini-P ,
Create a date type attribute which stores the Date of joining in schema (Example, @dateOfJoining)
Query:
@dateOfJoining EQUALS TO DateOnly(SubYears(GetDate(),1 ))
(Output: Recipient who had joined the organization 1 year Ago)
Thank you for your reply. But my requirement is that i need to send delivery for all the employees whoever is having the anniversary not only the 1st year but also for all the number of years.
eg: Employee :001 - First year anniversary celebration
Employee :002 - 4th year anniversary celebration
so the delivery should be sent according to their joining dates every year
Views
Replies
Total Likes
Hi @Sreevarshini-P ,
In that case you can use a condition like,
Day(@dateOfJoining) EQUAL TO Day(GetDate())
AND
Month(@dateOfJoining) EQUAL TO Month(GetDate())
In the above screenshot, you can use @dateOfJoining instead of date of birth
Thank you @ParthaSarathy for your quick reply
Views
Replies
Total Likes