Help...Date, If Statement w/formula
What i need to do is change a formula for selected individuals but that formula change has to do in affect at a certain date to now on. I have the formula the way i want im just not to sure how to add in the date part. This is what i have so far: if((input.Consultant_Name == "Roy Fields")) { input.Service_Fee = ((input.Bill_Rate - input.Pay_Rate) * input.Hours_Worked * 0.3); } And the date that i need to go into affect is April 5, 2010...Im just not to sure how to add that in.