Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Info |
---|
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial. |
Image RemovedImage Added | Arithmetic Op |
---|---|
Performs various mathematical operations from simple addition/subtraction to complex date/time calculations |
Contents
Note |
---|
If you want to know how to do calculations between dates and times, go straight to the bottom of this page! |
Status | ||||||
---|---|---|---|---|---|---|
|
Code Block | ||||
---|---|---|---|---|
| ||||
[Left Value] [+] [Right Value] = [Result Value] |
Parameters
Image RemovedImage Added
Operators
Operator Meaning Example + Add two operands or unary plus x + y +2 - Subtract right operand from the left or unary minus x - y -2 * Multiply two opeands x * y / Divide left operand by the right one (always results into float) x / y % Modulus - remainder of the division of left operand by the right x % y (remainder of x/y) // Floor division - division that results into whole number adjusted to the left in the number line x // y ** Exponent - left operand raised to the power of right x**y (x to the power y)
Anchor | ||||
---|---|---|---|---|
|
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!)
Status | ||||||
---|---|---|---|---|---|---|
|
Code Block | ||||
---|---|---|---|---|
| ||||
Left Value {{user.variable1}} Operator + Right Value 1 Result Value {{user.variable1}} |
Anchor | ||||
---|---|---|---|---|
|
2. When calculating dates/times, here are the tips!
2-1. Left Value can take all the following formats.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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].
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[n]day[n]hour [n]min [n]sec [n]msec [n]usec [n]week [n]month [n]year |
Note: [n] is an Integer.
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.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
|