Field Date Offset

To uses date offset a date filter must be used in the query (year, half year, quarter, month, week or day).

Date offset can be edited in the field-list or the inspector.

Date Offset

Depending on which date filter is used, values are retrieved in offset.

Samples:

• If a year-filter is used in the query with the value 2020, a date offset vof 1 returns the value of 2021.
• If a month-filter is used in the query with the value 2020-03, a date offset of -12 returns the value of 2019-03.

Day Offset

When a day-filter is used, whole months and years can be shifted.

• An offset value of a day filter that is divisible by 30 shifts months. E.g. a filter value of 2020-05-10 with an offset value of 90 becomes 2020-08-10.
• An offset value of a day filter that is divisible by 360 shifts years. E.g. a filter value of 2020-05-10 with an offset value of -360 becomes 2019-05-10.