Versions Compared

Old Version 8

changes.mady.by.user Former user

Saved on

compared with

New Version 9

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
1.815.1042
1.815.1042

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!



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


Status
subtletrue
colourGreen
titleExample

Code Block
languagexml
linenumberstrue
[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)



Anchor
Tip1
Tip1

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
subtletrue
colourGreen
titleExample
  When you want to user {{user.variable1}} as a counter for increment of 1


Code Block
languagexml
linenumberstrue
Left Value     {{user.variable1}}
Operator      +
Right Value   1
Result Value {{user.variable1}}

Anchor
Tip2
Tip2


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

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

Code Block
languagexml
themeConfluence
linenumberstrue
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
languagexml
themeConfluence
linenumberstrue
[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.