Page Comparison

...

...

...

Performs various mathematical operations from simple addition/subtraction to complex date/time calculations

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!

[Left Value] [+] [Right Value] = [Result Value]

• Parameters

  Image Removed

Operators

...

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!)

Left Value     {{user.variable1}}
Operator      +
Right Value   1
Result Value {{user.variable1}}

...

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

...

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.

...

...

YYYY|YY(Year) MM|M(Month) DD|D(Day) hh|h(Hour) mm|m(Minute) ss|s(Second)

You can combine then in various orders like shown in examples below.

EXAMPLE1

June 03, 2019

YYYY.MM.DD => 2019.06.03

YY.MM.DD => 19.06.03

M/D => 6/3

EXAMPLE2

Jun 03, 2019 13: 02: 03

M/D hhmmss=> 6/3 130203

M/D h:m=> 6/3 13:2

 If you input data to ‘Custom Date Format’ field, regardless of ‘Out Date Format’, or ‘Out Date Time Format’ settings, only the custom date is applied. 

Image Removed