RULE Problem

customaware

I have the following Rule on a BO....

IF
/* Usual Non Working Day. EDLH Duration = 0. No Event. No Toggle Shift */
 
EmployeeLabourMonth.D18T WAS CHANGED AND 
CHARS_FROM_LEFT(EmployeeLabourMonth.D18T,1)<>'-' AND
EmployeeLabourMonth.ps_EDLH18.Duration=0 AND 
EmployeeLabourMonth.ps_EDLH18.ps_AbsenceApplicationEvent IS UNDEFINED
THEN 

EmployeeLabourMonth.D18WD='Yes'
EmployeeLabourMonth.D18D=AS_NUMBER(EmployeeLabourMonth.D18T)*3600000 
EmployeeLabourMonth.ps_EDLH18.TimeStart=EmployeeLabourMonth.ob_EmployeeSalaryPlanPeriod.ps_EmployeePayrollSettings.DefaultTimeStart
EmployeeLabourMonth.ps_EDLH18.TimeEnd=EmployeeLabourMonth.ps_EDLH18.TimeStart+EmployeeLabourMonth.D18D

ELSE

IF
/* Usual Non Working Day. EDLH Duration = 0. No Event. Toggle Shift */
 
EmployeeLabourMonth.D18T WAS CHANGED AND 
CHARS_FROM_LEFT(EmployeeLabourMonth.D18T,1)='-' AND
EmployeeLabourMonth.ps_EDLH18.Duration=0 AND 
EmployeeLabourMonth.ps_EDLH18.ps_AbsenceApplicationEvent IS UNDEFINED
THEN 

EmployeeLabourMonth.D18WD='Yes' 
EmployeeLabourMonth.D18T=REPLACE_PATTERN (EmployeeLabourMonth.D18T,'-','')
EmployeeLabourMonth.D18D=AS_NUMBER(EmployeeLabourMonth.D18T)*3600000 
EmployeeLabourMonth.ps_EDLH18.TimeStart=EmployeeLabourMonth.ob_EmployeeSalaryPlanPeriod.ps_EmployeePayrollSettings.DefaultTimeStart
EmployeeLabourMonth.ps_EDLH18.TimeEnd=EmployeeLabourMonth.ps_EDLH18.TimeStart+EmployeeLabourMonth.D18D
ToggleDayshiftNightshift USING EmployeeLabourMonth.ps_EDLH18

In the logs I am seeing this error.....
Clearly it is concerning the 2nd line of each IF.

CHARS_FROM_LEFT Error.jpg

Wondering if anyone can either spot what is wrong and / or suggest how to fix please?

Jaymer

Maybe just the intricacy of the NOT

1) TRY SUBSTRING
2) try > ‘-‘ instead of <>

RLJB

Mark is

CHARS_FROM_LEFT(EmployeeLabourMonth.D18T,1)='-'

just checking if it is a negative number?

if so, why not use <0

also, we have found issues with the char - there seems to be different types of -

customaware

Good one Rod.

Never crossed my mind to test a string for less than zero but it works.

Thanx.