I am working on a field that pulls a result based on a number range. I aim to convert the number of days from a person's hire date and an incident date to a set phrase such as "Less than 3 Months", "4 Months to 1 Year", etc. My first field converts the difference between their hire date and the incident date to the number of days. My thought was to create a formula that says if the number of days is between 0-90, then the result is "less than three months," and so forth. My fields are "Hire Date", "Incident Date", & "DateDiff". The field I need to formulate is "Length of Service". What is the best approach to get my outcome?
Solved! Go to Solution.
I can't seem to add additional outcomes without getting an error. Here is the formula that works but adding another IF gives it an error. I am sure it is something simple. Is it best to copy and paste one of the IF lines then change the details?