AnsweredAssumed Answered

Timesheet Automatic Conditional expression

Question asked by stephen_floyd on Mar 27, 2014
Latest reply on Mar 28, 2014 by stephen_floyd

Hi All

I am trying to write an expression in our timesheet conditional approval process and I'm hitting a brick wall. This is the current one

( ( ( ( ( Timesheet.thisTimesheet Time Periods Ago = 0 ) or ( Timesheet.thisTimesheet Time Periods Ago = -1 ) ) and ( Timesheet.thisTimesheet Resource Type = 'Labor' ) ) and ( Timesheet.thisTimesheet Total >= 10 ) ) and ( Timesheet.thisTimesheet Total <= 50 ) )

The Problem I have I want to increase the amount of weeks to less than 4 weeks ago instead less than 1 week ago (highlight). You would think that the simple thing here is place a -4 but no that only automactically approves timesheets 4 weeks ago but leaves timesheets 1,2 and 3 weeks ago in the submitted status which I don't want.

I also tried to copy the same rules 4 times and place -1, -2, -3 etc but when I tested this It's automatically approving timesheet from last year and the year before.....

Has anyone got a simple expression that could help me out.

Thanks

Stephen

Outcomes