Note |
---|
If you want to know how to do calculations between dates and times, go straight to the bottom of this page! |
Contents
Status | ||||||
---|---|---|---|---|---|---|
|
Code Block | ||||
---|---|---|---|---|
| ||||
[Left Value] [+] [Right Value] = [Result Value] |
Parameters
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.
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.
Latest Update 2021.11.15
New! The Arithmetic Op plugin can now handle data anddatetime
format from Europe.You will find a new menu to explicitly specify the formats in the advanced menu.