I have a small problem in the week comparison field. It doesn't show me the 'smaller than' option in the dropdown. So now I have something like 'productionweek is if so_productionweek < format_date(get_date('today'),'W') end'. Don't know if that will work.

The second to last where clause should check for 'A', not 'B'. It's like every expression I write results in the 'else' clause. What am I doing wrong?
Hmm, it looks like the workflow is working when I test it. The eval script doesn't do a live check maybe?
By the way, I used a little trick to check the week, since 'smaller then' was not available:

I used the field 'so_productionyear' for comparison to check against (using 'is'). Then I used:

Code:

if so_productionweek < format_date(get_date('today'),'W') then so_productionyear else '1000' end

So basically, when then productionweek is in the past, I made productionyear check if it was itself, otherwise I returned something that will never be true ('1000').

If you get the SQL I understand that you are creating a scheduled workflow. Scheduled workflows do not support expressions because they would need to be translated to SQL which is VERY complex. In scheduled workflows only basic conditional operations that can be directly translated to SQL are supported.

I would suggest you create a numeric custom field and fill it in with the value in the picklist with an update field workflow and then create the scheduled workflow based on the numeric field.