Would this also work in reports by the way?
EDIT:
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.
SECOND EDIT:
Changed that to:
if so_productionweek < format_date(get_date('today'),'W') true else false end. Hopefully the workflow expression now returns true or false, making the condition functional.
THIRD EDIT:
OK, my second edit broke the application, so no dice there.
EDIT:
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.
SECOND EDIT:
Changed that to:
if so_productionweek < format_date(get_date('today'),'W') true else false end. Hopefully the workflow expression now returns true or false, making the condition functional.
THIRD EDIT:
OK, my second edit broke the application, so no dice there.