If you want to know how to do calculations between dates and times, go straight to the bottom of this page! |
[Left Value] [+] [Right Value] = [Result Value] |
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) |
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}} |
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.
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.