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
This is my formula:
DATETIME_FORMAT(DATEADD({Start Date}, -7, 'days'), 'YYYY-MM-DD')
This is my formula:
DATETIME_FORMAT(DATEADD({Start Date}, -7, 'days'), 'YYYY-MM-DD')
DATETIME_FORMAT(DATEADD({hire date}, 0 - MOD(DATETIME_DIFF({hire date}, '2022-05-08', 'days'), 7) + 1, 'days'), 'M/D/YYYY')
We found this as a solution:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.