Date condition

If the condition is executed on multiple objects, you can use the Logical operation(Objects) property to determine how the results of the condition (true or false) are linked and evaluated:

• OR: Condition is true if one of the results or all results are true.

• AND: Condition is true if all results are true.

• Exclusive OR: Condition is true if one of the results is true and the rest are false.

You can create a query here which determines the objects for which the condition is evaluated.

If the condition is to be executed on objects that are referenced in another object, you can create a query here that determines the corresponding objects.

Select here the logical operation of the attributes for the evaluation of the condition:

• OR: The condition is true if one of the attributes or all attributes have the value set or not set, depending on whether the property Value set is enabled or disabled.

• AND: The condition is true if all attributes have the value set or not set, depending on whether the property Value set is enabled or disabled.

• Exclusive OR: The condition is true if any of the attributes have the value set or not set, depending on whether the property Value set is enabled or disabled, and all other attributes have the opposite.

Reference here the attributes that are to be checked.

Date / Date 2

(date selection field)

Enter the date values in these two properties as comparison values for the attribute value, which have different meanings depending on the comparison operator.

If you do not specify a date for the date condition here, the current date (server time) will be used.

Comparator

Select here the comparison operator for the data stored in the Date and Date 2 properties and the attribute value of the attribute you referenced under the Attributes property.

Include boundary values

With this property the limit values Date and Date 2 are included as possible results when comparing.

(This option is only relevant for the comparators)

Use day resolution

If the option is enabled, only the day of the date values will be compared.

Days (x) / Days (y)

Enter here the date values relevant for special comparison operators to narrow down time spans relative to the current day (example: Between x and y days before / after today).

You can activate the enabled attributes of a query and condition in the Variables property so that they can be changed by users at the time of execution.

Comparison operators independent of the year from Date

Same day

Day number of date, i.e. day 15 on 6/15/2019

2/15/2018, 8/15/2017

Same month

Month number from date i.e. month 06. on 6/15/2019

6/24/2020, 6/12/2018

Same quarter

Quarter number of date, i.e. 2nd quarter on 6/15/2019

4/10/2015, 6/5/2020

Comparison operators in relation to Date / if necessary also Date2

Yesterday

The day before the day of date, i.e. 6/14/2019 on 6/15/2019

6/14/2019

Today

The day of date, i.e. 6/15/2019 on 6/15/2019

6/15/2019

Tomorrow

The day after the day of date, i.e. 6/16/2019 on 6/15/2019

6/16/2019

Before day

All days before the day of date, i.e. "Found date < date”, i.e. all dates less than 6/15/2019 on 6/15/2019

<= 6/14/2019, e. g. 3/02/2014

After day

All days after the day of date, i.e. "Found date > date”, i.e. all dates greater than 6/15/2019 on 6/15/2019

=> 6/16/2019, e. g. 4/15/2022

Between date (1) and date 2

All days in the period between date and date2 ,

i.e. (6/15), 6/16 6/17, (6/18)

on date = 6/15 and date 2 = 6/18

6/16-6/17

respectively

6/15/19 - 6/18/19 (limits included)

Last week

the week before the week of date, i.e. one day in week 23 on 6/15/2019 in week 24

6/06/2019 - 6/12/2019

This week

The same week of the same year

of date, i.e. week 24 in 2019 on 6/15/2019 in week 24

6/13/2019 - 6/19/2019

Next week

Next week

of date, i.e. week 25 in 2019 on 6/15/2019 in week 24

7/20/2019 - 7/26/2019

Last month

Month before date, i.e. month 5 for 6/15/2019

5/01/2019 - 5/31/2019

This month

the same month

Month number of date, i.e. month 6 for 6/15/2019

6/01/2019 - 6/30/2019

Next month

Month after

date, i.e. 7 on 6/15/2019

7/01/2019 - 7/31/2019

Last quarter

Quarter before

date, i.e. 1st quarter on 6/15/2019 in the 2nd quarter

1/01/2019 - 1/31/2019

This quarter

The same quarter the same year

of date, i.e. 2nd quarter in 2019 on 6/15/2019

4/01/2019 - 6/30/2019

Next quarter

following quarter from date, i.e. 3rd quarter in 2019 on 6/15/2019 in the 2nd quarter 2019

7/01/2019 - 9/30/2019

Last year

Year before

date, i.e. year 2018 on 6/15/2019

1/01/2018 - 12/31/2018

This year

The same year

of date, i.e. 2019 on 6/15/2019

1/01/2019 - 1/31/2019

Next year

The year after date, i.e. year 2020 on 6/15/2019

1/01/2020 - 1/31/2020

Comparators with time periods relative to the current date (today)

Till x days before (-) / after (+) today

Period up to x days before the current date (today) or up to x days after the current date (today)

up to 6 days before the current date, i.e. up to 6 days before 3/27/2019, for example

until 6 days before today

From x days before (-) / after (+) today

Period from x days before the current date (today) or from x days after the current date (today)

from 6 days after the current date, i.e. from 6 days after 3/27/2019, for example

from 6 days after today

Between x and y days before (-) / after (+) today.

Period between x days and y days before the current date or between x days and y days after the current date

between 3 and 8 days before the current date, i.e. between 3 and 8 days before 5/12/2019, for example

between 3 and 8 days before 5/12/2019