Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 02, 2025 11:39 AM
I need to calculate different due dates for tasks based on Workday instead of dateadd. Here is my original formula:
SWITCH(
Task,
'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'),
'Assign desk space for new hire', DATEADD({Hire Date}, -3, 'days'),
'Give Uniform', {Hire Date},
'Collect how to contact employee while OOO', DATEADD({Hire Date}, 1, 'days'),
'Verify that background check has been completed', DATEADD({Hire Date}, -7, 'days'), 'Hiring Manager select starting date', DATEADD({Hire Date}, -21, 'days')
)
When i change DATEADD to WORKDAY it gives me an error message. What else do I need to change?
Thanks!
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2025 02:11 AM
Hey @ler1995,
I suppose you have to update your WORKDAY formula. This formula can receive the {hire date} field, then you add the number of days (positive and negative numbers accepted). Did you add a 3rd element in this formula?
Thansk
Dimitris Goudis
