Date & Date/time

Date Filters

Property is of type 'date'.

Is at (date)

• Definition: Checks if the date is exactly equal to a specific value.

• Use Case: Useful for exact date matches.

  • Example: Filter users whose subscription started on January 1, 2023.

    • subscription_start_date is at "2023-01-01"

Before (date)

• Definition: Checks if the date is before a specific value.

• Use Case: Useful for filtering dates before a certain point in time.

  • Example: Filter users whose subscription started before January 1, 2023.

    • subscription_start_date before "2023-01-01"

After (date)

• Definition: Checks if the date is after a specific value.

• Use Case: Useful for filtering dates after a certain point in time.

  • Example: Filter users whose subscription started after January 1, 2023.

    • subscription_start_date after "2023-01-01"

Between (date) and (date)

• Definition: Checks if the date falls within a specific range (inclusive of the boundaries).

• Use Case: Useful for defining date ranges.

  • Example: Filter users whose subscription started between January 1, 2023, and March 1, 2023.

    • subscription_start_date between "2023-01-01" and "2023-03-01"

Exactly (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date is exactly a specific time period in the past or future.

• Use Case: Useful for targeting users based on a specific time period relative to the current date.

  • Example: Filter users whose subscription started exactly 30 days ago.

    • subscription_start_date exactly 30 days in the past

Before (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date is before a specific time period in the past or future.

• Use Case: Useful for filtering dates that occurred before a relative time period.

  • Example: Filter users whose subscription started more than 6 months ago.

    • subscription_start_date before 6 months in the past

After (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date is after a specific time period in the past or future.

• Use Case: Useful for filtering dates that occurred after a relative time period.

  • Example: Filter users whose subscription started within the last 7 days.

    • subscription_start_date after 7 days in the past

Day equals

• Definition: Checks if the day of the date matches a specific day (e.g., 01 for the 1st of the month).

• Use Case: Useful for targeting specific days, such as birthdays or anniversaries.

  • Example: Filter users whose birthday falls on the 15th of any month.

    • birth_date day equals "15"

Month equals

• Definition: Checks if the month of the date matches a specific month (e.g., 01 for January).

• Use Case: Useful for targeting specific months, such as seasonal campaigns or anniversaries.

  • Example: Filter users whose subscription started in December.

    • subscription_start_date month equals "12"

Is empty

• Definition: Checks if the date field is empty (i.e., no value is present).

• Use Case: Useful for identifying users with missing or incomplete date data.

  • Example: Filter users who do not have a subscription start date.

    • subscription_start_date is empty

Is not empty

• Definition: Checks if the date field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring that all users have a date value.

  • Example: Filter users who have a subscription start date.

    • subscription_start_date is not empty

Date-Time Filters

The same logic applies to date-time fields, but with the added precision of time. We support up until minutes.

Is at (date-time)

• Definition: Checks if the date-time is exactly equal to a specific value.

• Use Case: Useful for exact timestamp matches.

  • Example: Filter users who logged in on January 1, 2023, at 12:00 PM.

    • last_login is at "2023-01-01 12:00"

Before (date-time)

• Definition: Checks if the date-time is before a specific value.

• Use Case: Useful for filtering timestamps before a certain point in time.

  • Example: Filter users who logged in before January 1, 2023, at 12:00 PM.

    • last_login before "2023-01-01 12:00"

After (date-time)

• Definition: Checks if the date-time is after a specific value.

• Use Case: Useful for filtering timestamps after a certain point in time.

  • Example: Filter users who logged in after January 1, 2023, at 12:00 PM.

    • last_login after "2023-01-01 12:00"

Between (date-time) and (date-time)

• Definition: Checks if the date-time falls within a specific range (inclusive of the boundaries).

• Use Case: Useful for defining time ranges.

  • Example: Filter users who logged in between January 1, 2023, at 12:00:00 PM and January 2, 2023, at 12:00 PM.

    • last_login between "2023-01-01 12:00" and "2023-01-02 12:00"

Exactly (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date-time is exactly a specific time period in the past or future.

• Use Case: Useful for targeting users based on a specific time period relative to the current date-time.

  • Example: Filter users who logged in exactly 24 hours ago.

    • last_login exactly 24 hours in the past

Before (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date-time is before a specific time period in the past or future.

• Use Case: Useful for filtering timestamps that occurred before a relative time period.

  • Example: Filter users who logged in more than 1 year ago.

    • last_login before 1 year in the past

After (time period) (days, hours, months, years) in the past/future

• Definition: Checks if the date-time is after a specific time period in the past or future.

• Use Case: Useful for filtering timestamps that occurred after a relative time period.

  • Example: Filter users who logged in within the last 7 days.

    • last_login after 7 days in the past

Day equals

• Definition: Checks if the day of the date-time matches a specific day.

• Use Case: Useful for targeting specific days, such as recurring activities.

  • Example: Filter users whose last login occurred on the 15th of any month.

    • last_login day equals "15"

Month equals

• Definition: Checks if the month of the date-time matches a specific month.

• Use Case: Useful for targeting specific months, such as seasonal campaigns.

  • Example: Filter users whose last purchase occurred in December.

    • last_purchase month equals "12"