What does Spirion Sensitive Data Platform define as a "month," when used as a Tag attribute?

This article provides details about the 'month' attribute, which is used in Spirion Sensitive Data Platform in functions such as conditional Tags.

Overview

In Spirion Sensitive Data Platform (SDP), date and time definitions differentiate between the following:

  • Calendar-based months
  • Relative sliding-window month intervals
  • Fixed day counts

"Month" Time Interval Examples

When you create a Tag in Spirion Sensitive Data Platform you can include time attributes such as "Last Month" and "Older Than X Months."

Search Date/Time - Last Month

Search Date/Time - Older Than X Months

What is the Difference between time intervals?

1. Month-Based Tag and Filter Operators

Operator

Type

Definition & Behavior

Older Than X Months (shown in screenshot above)

Relative / Sliding Window

Matches timestamps older than X calendar month(s) prior to the current evaluation date/time (< CurrentDate - X months).

For X=1, it targets records older than 1 month ago.

Last X Months

Relative / Sliding Window

Matches timestamps occurring within the rolling window of the previous X calendar month(s) up to the current date/time (>= CurrentDate - X months).

This Month

Calendar Period

Matches timestamps occurring from the 1st day of the current calendar month through the current timestamp.

Last Month

Calendar Period

Matches timestamps that fell entirely within the preceding calendar month (from the 1st day to the final day of the previous month).

2. How Spirion Sensitive Data Platform Distinguishes “Month” from “Days”

  • Month Calculation (Older Than X Months / Last X Months):
    • Uses calendar month arithmetic
    • Example: Standard date arithmetic/DATEADD(month, -X, ...), subtracting X months from the current day and month.
  • Fixed Day Count (Last 30 Days / Older Than X Days):
    • If a fixed 30-day window is needed rather than calendar-month subtraction, Spirion Sensitive Data Platform provides explicit day-based operators (Last 30 days, Last X Days, and Older Than X Days).