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.

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, 14 days ago, or 1 year ago. The list of relative date values includes a series of common ranges, but you may also type in a more specific range, such as 2 months ago or 5 days ago.
Relative date values
Value |
Description |
---|---|
Tomorrow |
Starts at 12:00:00 AM of the day after the current day. For example, if the current day is “Thursday 01 / 12 / 2023” then tomorrow is “Friday 01 / 13 / 2023”. |
Today |
Starts at 12:00:00 AM (or at the current time) on the current day and continues for 24 hours. For example, if the current day is “Thursday 01 / 12 / 2023” then today is “Thursday 01 / 12 / 2023”. |
Yesterday |
Starts at 12:00:00 AM of the day before the current day. For example, if the current day is “Thursday 01 / 12 / 2023” then yesterday is “Wednesday 01 / 11 / 2023”. |
N days ago |
Starts at 12:00:00 AM of the day N days before the current day. For example, if the current day is “Thursday 01 / 12 / 2023”, then:
|
1 month ago |
Starts at 12:00:00 AM of the same day of the month that is 1 month before the current month. For example, if the current day is “Thursday 01 / 12 / 2023” then 1 month ago is “Monday 12 / 12 / 2022”. |
1 year ago |
Starts at 12:00:00 AM of same day of the year that is 1 year before the current year. For example, if the current day is “Thursday 01 / 12 / 2023” then 1 year ago is “Wednesday 01 / 12 / 2022”. |