--- schema_version: "1" id: 5d07269790be06ee5788dea918c506ede11dbc177d2cfc19d028d5660bf7dab3 title: Activation Filter Operators collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_activation_operators.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_activation_operators.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 7d8e2cf6ac01e17211c5a8d557b19c30e867c17de699832a61b7395e46539951 description: Use filter operators to refine the data payload sent to your activation targets. When defining activation filters, you can apply these operators to specific attributes to ensure only the most relevant data triggers an update in your downstream systems. products: - Data 360 release: "264" --- # Activation Filter Operators Use filter operators to refine the data payload sent to your activation targets. When defining activation filters, you can apply these operators to specific attributes to ensure only the most relevant data triggers an update in your downstream systems. ## Text Operators These operators are available for attributes with a text data type.

Operator	Description	Example
Is Changed	Checks if the value of the attribute has changed on the event being evaluated. If the value remains the same, the record is filtered out.	Attribute: Loyalty_Status Value: Is Changed
No Value	Matches records where the attribute is null or empty.	Attribute: Email_Address Value: No Value
Has Value	Matches records where the attribute isn’t null or empty.	Attribute: Phone_Number Value: Has Value
Equal	Matches records where the attribute exactly matches the specified value.	Attribute: Gender Value: ‘Female’
Not Equal	Matches records where the attribute doesn’t match the specified value.	Attribute: Region Value: ‘North’
Contains	Matches records where the attribute contains the specified string. This operator ignores null values.	Attribute: Job_Title Value: ‘Manager’
Does Not Contain	Matches records where the attribute doesn’t contain the specified string. This operator ignores null values.	Attribute: Email Value: ‘test’
Begins With	Matches records where the attribute starts with the specified characters.	Attribute: Postal Code Value: ‘94’
Ends With	Matches records where the attribute ends with the specified characters.	Attribute: Email Value: ‘.org’
Exists As A Whole Word	Matches records where the specified string exists as a distinct word within the attribute.	Attribute: Description Value: ‘urgent’
Matches	Matches records based on a specified pattern (often used for wildcards or specific formatting).	Attribute: SKU Value: ‘AB-????’
Does not Match	Matches records that don’t follow the specified pattern.	Attribute: SKU Value: ‘X-????’
In	Matches records where the attribute matches one of the values in a provided list.	Attribute: State Value: ‘CA, NY, TX’
Not In	Matches records where the attribute doesn’t match any value in a provided list.	Attribute: Status Value: ‘Inactive, Suspended’

## Number Operators These operators are available for attributes with a **Number** data type.

Operator	Description	Example
No Value	Matches records where the value is null.	Attribute: Credit_Score Value: No Value
Has Value	Matches records where the value isn’t null.	Attribute: Phone_Number Value: Has Value
Equal	Matches records where the value equals the specified number.	Attribute: Age Value: 25
Not Equal	Matches records where the value doesn’t equal the specified number.	Attribute: Items_in_Cart Value: 0
Less Than	Matches records where the value is smaller than the specified number.	Attribute: Inventory_Count Value: 30
Less Than or Equal	Matches records where the value is smaller than or equal to the specified number.	Attribute: Order_Total Value: 50.00
Greater Than	Matches records where the value is larger than the specified number.	Attribute: Lifetime_Value Value: 1000
Greater Than or Equal	Matches records where the value is larger than or equal to the specified number.	Attribute: Loyalty_Points Value: 500
Between	Matches records where the value falls between two specified numbers (inclusive).	Attribute: Age Value: 18, 35
Not Between	Matches records where the value falls outside two specified numbers.	Attribute: Risk_Score Value: 1, 5

## Date and Timestamp Operators These operators are available for Date and Timestamp (Date/Time) data types.

Operator	Description	Example
No Value	Matches records where the date is null.	Attribute: Expiry_Date Value: No Value
Has Value	Matches records where the date isn’t null.	Attribute: Activation_Date Value: Has Value
Anniversary Of	Matches records where the month and day match the current date, regardless of year.	Attribute: Birthdate Value: Anniversary Of
Not Anniversary Of	Matches records where the month and day don’t match the current date.	Attribute: Join_Date Value: Not Anniversary Of
Equal	Matches records on a specific date.	Attribute: Event_Date Value: 2025-01-01
Before	Matches records before a specific date.	Attribute: Created_Date Value: 2024-01-01
After	Matches records after a specific date.	Attribute: Last_Modified Value: 2025-06-01
Equal or Before	Matches records on or before a specific date.	Attribute: Due_Date Value: 2025-12-31
Equal or After	Matches records on or after a specific date.	Attribute: Start_Date Value: 2025-01-01
Between	Matches records falling between two specific dates.	Attribute: Promo_Period Value: 2025-01-01, 2025-01-31
Not Between	Matches records falling outside two specific dates.	Attribute: Blackout_Dates Value: 2025-12-20, 2025-12-31

## Relative to Now Filters Use these operators to filter dates relative to the moment that the activation runs. These are useful for rolling windows (for example, "users active in the last 30 days").

Operator	Description	Example
In the next N days	Matches dates occurring within the next specified number of days.	Attribute: Renewal_Date Value: 30
In the last N days	Matches dates that occurred within the past specified number of days.	Attribute: Last_Purchase Value: 90
In the next N months	Matches dates occurring within the next specified number of months.	Attribute: Target_Date Value: 3
In the last N months	Matches dates that occurred within the past specified number of months.	Attribute: Last_Login Value: 6
In the next N years	Matches dates occurring within the next specified number of years.	Attribute: Maturity_Date Value: 1
In the last N years	Matches dates that occurred within the past specified number of years.	Attribute: Join_Date Value: 5
Before the last N days	Matches dates that occurred before a rolling window of days.	Attribute: Last_Contact Value: 180 (Filters for users not contacted in over 6 months)