Auto Enter Calculation
I need help with an auto enter calculation.
I want an employee to hit a button, that will set todays date, if they hit it again, it will set the date they hit it.
I then need to do a found set based on that date fitting into commissions periods... December 16-31, January 1-15.
I do not want to go back next year and change my case statement.
Set field commission date... Case ( Commission::date > 12/16/2015 or < 12/31/2015; 12/16/2015...12/31/2015
This is my question... how do i set the year just once?
I can't quite figure out what you are trying to do here.
if they hit it again, it will set the date they hit it.
Huh? Can't tell what you mean by that.
I then need to do a found set based on that date fitting into commissions periods
Does that mean that you are trying find all records marked 1, 2, 3 ... for dates in the specified ranges?