IIf(Format(Now(),”yyyy”) + 0 > Format([sol_date_reqd],”yyyy”) + 0,-1,IIf(Format(Now(),”yyyy”) + 0 < Format([sol_date_reqd],"yyyy") + 0,IIf(Format([SOL_DATE_REQD],"ww",1,1) + 0 > IIf(Format(Now(),”ww”,1,1) + 10 > 52,Format(Now(),”ww”,1,1) - 42,Format(Now(),”ww”,1,1) + 10),IIf(Format(Now(),”ww”,1,1) + 10 > 52,Format(Now(),”ww”,1,1) - 42,Format(Now(),”ww”,1,1) + 10),Format([SOL_DATE_REQD],”ww”,1,1) + 0),IIf(Format([sol_date_reqd],”ww”,1,1) + 0 < Format(Now(),"ww",1,1) + 0,-1,IIf(Format([sol_date_reqd],"ww",1,1) + 0 > Format(Now(),”ww”,1,1) + 10,Format(Now(),”ww”,1,1) + 10,IIf(Format([sol_date_reqd],”ww”,1,1) + 0 > 52,1,Format([sol_date_reqd],”ww”,1,1) + 0)))))
That’s [...]