Hey,
Can anyone please help me to understand this message?
I have that script-code:
if(IsNull(Step_Time_Closed),
Interval(
(RangeMin(frac($(vToday)), MakeTime(17))
- RangeMax(frac(Step_Actual_Time), MakeTime(7,30)))
+( NetWorkDays(Step_Actual_Time+ 1, $(vToday)) * MakeTime(9,30) )
)) As Time_StepToToday,
The error:
The following error occurred:
Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...
The error occurred here:
LOAD *, Interval( (RangeMin(frac(Step_Time_Closed), MakeTime(17,00)) - RangeMax(frac(Step_Actual_Time), MakeTime(7,30))) + (NetWorkDays(Step_Actual_Time + 1, Step_Time_Closed) * MakeTime(9,30)) ) as Step_Handling_Time, if(IsNull(Step_Time_Closed), Interval( (RangeMin(frac(), MakeTime(17)) - RangeMax(frac(Step_Actual_Time), MakeTime(7,30))) +( NetWorkDays(Step_Actual_Time+ 1, ) >>>>>>*<<<<<< MakeTime(9,30) ) )) As Time_StepToToday,
Your answer is really appreciated!
