Invalid date values for profile attributes breaks filters/groups
Last updated 2021-10-13 ·Reference W-7007836 ·Reported By 0 users
Marketing Cloud profile attributes with the ‘date’ data type will accept any date entries. When using these attributes for filters or groups though, only the range of 1753-01-01 to 9999-12-31 is allowed. It is very common for clients to use values outside of this range in their ‘date’ attributes, such as 01/01/0001. If a value such as this exists, and that attribute is used in a filter, it breaks the filter. No results will be returned and an error will be thrown on the backend.
I have a ‘Birthdate’ field using the ‘date’ datatype. One of my subscriber has input a value of 01/01/0001. I then create a Group based on this ‘Birthdate’ and run it. No results are returned and it fails on the backend.
Ensure that all values for profile attributes using the 'date' data type fall within the range of 1753-01-01 to 9999-12-31.
Reported By (0)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.