Good evening everyone!
I am creating a screen in Processbook with VBA that calculates the time that a pump is in operation. The period is defined by an external database value,
however when using the expression PE, the following error "Error in call:PI PE syntax error in Expression. [-12301] Performance Equation parsing error" is generated.
TimeStart = dataResult '(date I get from a database)
TimeEnd = "*"
PE = "TimeEQ ('" & idPump & "', '" & TimeStart & "', '" & TimeEnd & "'," "ON" ") / 3600"
Set vals1 = ipiCalc.Calculate (TimeStart, TimeEnd, PE, stRecordedValues, "")
cnt = vals1.count
partial_txt = FormatNumber ((vals1 (2) .Value), 2)
I tested some dates at the start time and realized that in the North American standard dd-mmm-yyy hh: mm: ss [.nnn] works perfectly,
however when changing to the portuguese standard brazil dd/mm/yyyy hh:mm:ss[.nnn] the mentioned error occurs.
Could anyone help me on this issue?