1 Reply Latest reply on Apr 28, 2015 9:29 PM by philmodjunk

    Auto Enter Calculation

    Kirk_1

      Title

      Auto Enter Calculation

      Post

      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?

        • 1. Re: Auto Enter Calculation
          philmodjunk

          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?