Arithmetic Op

This function is one of Plugins Operation.You can find the movie in ARGOS video tutorial.



Arithmetic Op

Performs various mathematical operations from simple addition/subtraction to complex date/time calculations.



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,

If you want to know how to do calculations between dates and times, go straight to the bottom of this page!

Contents

  1. When using User Variables, you can store the Result Value in one of the Left or Right values. (you can use it as a counter!)
  2. When calculating dates/times, here are the tips!





EXAMPLE

[Left Value] [+] [Right Value] = [Result Value]



  • Parameters


  • Operators

    OperatorMeaningExample
    +Add two operands or unary plusx + y +2
    -Subtract right operand from the left or unary minusx - y -2
    *Multiply two opeandsx * y
    /Divide left operand by the right one (always results into float)x / y
    %Modulus - remainder of the division of left operand by the rightx % y (remainder of x/y)
    //Floor division - division that results into whole number adjusted to the left in the number linex // y
    **Exponent - left operand raised to the power of rightx**y (x to the power y)



1. When using User Variables, you can store the Result Value in one of the Left or Right values. (you can use it as a counter!)


EXAMPLE  When you want to user {{user.variable1}} as a counter for increment of 1


Left Value     {{user.variable1}}
Operator      +
Right Value   1
Result Value {{user.variable1}}


2. When calculating dates/times, here are the tips!

  2-1. Left Value can take all the following formats.

YYYYMMDD
YYYY-MM-DD
YYYY/MM/DD
MMDDYYYY
MM-DD-YYYY
MM/DD/YYYY
B D YYYY
B D, YYYY
D B YYYY
YYYYMMDD-HHMMSS.mmm
YYYY-MM-DD HH:MM:SS.mmm
YYYY/MM/DD HH:MM:SS.mmm
MMDDYYYY-HHMMSS.mmm
MM-DD-YYYY HH:MM:SS.mmm
MM/DD/YYYY HH:MM:SS.mmm
YYYYMMDD-HHMMSS
YYYY-MM-DD HH:MM:SS
YYYY/MM/DD HH:MM:SS
MMDDYYYY-HHMMSS
MM-DD-YYYY HH:MM:SS
MM/DD/YYYY HH:MM:SS


 2-2. You can use only [+] or [-] operator.


 2-3. Right Value can take only the following “time-delta” notations. There is NO SPACE after [n].


n day
n hour
n min
n sec
n msec
n usec
n week
n month
n year

Note: [n] is an Integer.

(warning) There is NO SPACE after [n].


2-4. You can use date or datetime for the Right Value only when operator is [-].

In this case, if Left Value is date, then the Right Value must be date. If the Left Value is datetime, then the Right Value must be datetime.


2-5. You can customize date or datetime with Custom date format.


YYYY|YY(Year) MM|M(Month) DD|D(Day) hh|h(Hour) mm|m(Minute) ss|s(Second)

You can combine then in various orders like shown in examples below.


EXAMPLE1

June 03, 2019

YYYY.MM.DD => 2019.06.03

YY.MM.DD => 19.06.03

M/D => 6/3

EXAMPLE2

Jun 03, 2019 13: 02: 03

M/D hhmmss=> 6/3 130203

M/D h:m=> 6/3 13:2


(warning) If you input data to ‘Custom Date Format’ field, regardless of ‘Out Date Format’, or ‘Out Date Time Format’ settings, only the custom date is applied. 




Latest Update 2021.11.15

New! The Arithmetic Op plugin can now handle data and datetime format from Europe.

You will find a new menu to explicitly specify the formats in the advanced menu.


Return Code

CodeMeaning
0Operation Successful
99All Errors and Exceptions




All Plugins