I am trying to calculate the Due date based on the value "Recruitment Status" and then adding the number of days based on the selected status. I created the below formula but it is showing me an error:
I need help with revising the formula and suggesting the field type if I want a due date as the result
CASE WHEN [Recruitment Status] = "Pre-Post" THEN [Date extracted] + Days(7) WHEN [Recruitment Status] = "Post" THEN [Date extracted] + Days(1) WHEN [Recruitment Status] = "Selection" THEN [Date extracted] + Days(21) WHEN [Recruitment Status] = "Pre-Employment" THEN [Date extracted] + Days(21) WHEN [Recruitment Status] = "DCHR" THEN [Date extracted] + Days(7) WHEN [Recruitment Status] = "Post-Offer" THEN [Date extracted] + Days(7)
ELSE
END
Update your case statement as follows:
Case([Recruitment Status],
"Pre-Post", [Date Extracted] + Days(7),
"Post",[Date Extracted]+Days(1),
......
,null)
