What does Spirion Sensitive Data Platform define as a "month," when used as a Tag attribute?
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 |
|---|---|---|
| Relative / Sliding Window | Matches timestamps older than X calendar month(s) prior to the current evaluation date/time ( For X=1, it targets records older than 1 month ago. |
| Relative / Sliding Window | Matches timestamps occurring within the rolling window of the previous X calendar month(s) up to the current date/time ( |
| Calendar Period | Matches timestamps occurring from the 1st day of the current calendar month through the current timestamp. |
| 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, andOlder 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 (