## Case function to create brackets

Solved
Frequent Contributor
Posts: 106

# Case function to create brackets

Hi, can some one help me on this case function. I'm trying to create a new calculated column and employee hired between two dates, they get bonus based on the dates range I set.

Case

When  date(01/01/1976)<=t1.Employee_Hire_Date<=date(12/31/1985) then t1.Salary*.001

else t1.Salary

end

Accepted Solutions
Solution
‎09-23-2014 09:13 PM
Super User
Posts: 4,013

## Re: Case function to create brackets

Try this:

Case

When  "01/01/1976"d <=t1.Employee_Hire_Date<= "12/31/1985"d then t1.Salary*.001

else t1.Salary

end

All Replies
Solution
‎09-23-2014 09:13 PM
Super User
Posts: 4,013

## Re: Case function to create brackets

Try this:

Case

When  "01/01/1976"d <=t1.Employee_Hire_Date<= "12/31/1985"d then t1.Salary*.001

else t1.Salary

end

Posts: 1,270

## Re: Case function to create brackets

Based on your logic looks like you are trying to add bonus amount in salaries for the employees hired between the specified dates. So end variable will be salary again.

Case

When  "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*1.001

else t1.Salary end as Salary;

Otherwise, if need a bonus variable then

Case

When  "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*0.001

else 0 end as Bonus;

Frequent Contributor
Posts: 106

## Re: Case function to create brackets

Thank you.  It worked.

🔒 This topic is solved and locked.