Hello @rachel1990,
To trigger a flow based on a “date Property”, the profile property you are referencing must be in one of the following formats:
- 2014-09-01 13:34:08
- 2014-09-01 13:34:08+00:00
- 09/01/2014 13:34:08
- 09/01/14 13:34:08
- 09/01/2014 13:34
- 09/01/14 13:34
- 2014-09-01T13:34:08
- 1409529600 (Unix)
Therefore, the format you have of YYYY-MM-DD is absolutely correctly! However, should there be some data within this property that does not match any of those Accepted Date Formats such as if at one point you collected the data as “May 13, 2021”; this would contaminate this data set and cause Klaviyo to actually see the data set as a Text format as opposed to a Date format.
The easiest way to resolve this would be to create a segment of customers who has this specific profile property with rules such as “Properties about someone, loyalty_birthday_date is set”. With this segment, you can export this segment while including this “loyalty_birthday_date” custom profile property and within the resulting .CSV, locate any contacts/profiles who “loyalty_birthday_date” property is not in the accepted date formats. With these profiles/contacts located, you can either simply adjust them within the .CSV and re-import the .CSV back into Klaviyo or if there were just a handful of these profiles, you can locate them within your Klaviyo account by using the search bar within the Klaviyo interface and adjust this loyalty_birthday_date custom property within each of these profiles manually.
Once these changes have been updated and applied, give the Klaviyo system some time to reconcile these changes and attempting to create a new flow while selecting the “Date Property” trigger as opposed to the one already created! We want to create an all new flow so Klaviyo isn’t caching any of these old settings or profile formats.
Let me know how this goes!
David