Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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!



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


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.


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.



  • No labels