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.