Birthdates

The date of birth that is associated with an individual customer record.

You can access birthdates directly from the Segment Editor. To add this attribute to your segment, click Add criteria, select the Customer 360 table, select the Birthdate attribute, and then apply an condition.

Choose the birthdate attribute from the Segment Editor.

Available conditions

The following table lists the conditions that are available to this attribute.

Note

This attribute has a Date data type. All Date data types share the same set of conditions. Recommended conditions for this attribute are identified with “  Recommended” and conditions with more limited use cases are identified with “  Not recommended”.

Condition

Description

is

Avoid using is condition with this attribute unless you intend to use a specific date, such as “2022-08-22” (“yyyy-mm-dd”).

is after

  Recommended

is after uses the selected calendar date to then return all dates that occur after the selected date, excluding the selected date.

is before

  Recommended

is before uses the selected date to return all dates that occur before the selected date, excluding the selected date.

is between

  Recommended

is between returns dates that exist within a defined start and end date.

is not between

is not between returns order dates that exist outside of a defined start and end date.

is not NULL

is not NULL returns customer records that have a value.

is NULL

is NULL returns customer records that do not have a value.

is on or after

is on or after uses the selected calendar date to return all dates that occur on or after the selected date. Use a relative date to define a rolling window.

is on or before

is on or before uses the selected calendar date to return all dates that occur on or before the selected date. Use a relative date to define a rolling window.

About relative dates

A relative date is determined at the time a segment is run, where “today” is the day on which the segment is run. For example: “yesterday”, “30 days ago”, “5 days from today”, or “3 months ago”.