AnsweredAssumed Answered

How to work with date and time with the expression PE?

Question asked by Marinho on Aug 20, 2020
Latest reply on Sep 7, 2020 by jyi


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.

Example:

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?

Thank you

Outcomes