09-23-2014 08:22 PM
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.
When date(01/01/1976)<=t1.Employee_Hire_Date<=date(12/31/1985) then t1.Salary*.001
09-23-2014 09:57 PM
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.
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
When "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*0.001
else 0 end as Bonus;
Need further help from the community? Please ask a new question.