May 02, 2023 01:04 PM
Hello,
I need to calculate a date. Here is an example:
Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.
How can I calculate the date based on the weekday.
I have a formula, but it only works if employee starts on a Monday
Solved! Go to Solution.
May 05, 2023 01:11 AM
We found this as a solution:
May 02, 2023 01:04 PM
This is my formula:
DATETIME_FORMAT(DATEADD({Start Date}, -7, 'days'), 'YYYY-MM-DD')
May 02, 2023 02:55 PM
DATETIME_FORMAT(DATEADD({hire date}, 0 - MOD(DATETIME_DIFF({hire date}, '2022-05-08', 'days'), 7) + 1, 'days'), 'M/D/YYYY')
May 05, 2023 01:11 AM
We found this as a solution: