Skip to main content

Hi - I attended the webinar last night on this and have read most of the articles and comments too.

I had been collecting UK dates (DD/MM/YYYY) can couldn’t get the date property trigger “Birthday or “Date Of Birth” to show up on the Birthday flow.  I have now changed this on the database and there are 134 Birthdays which are configured MM/DD.  I have also changed the sign up forms so they will load with US oriented data (MM/DD).  I have deleted the flow I tried to create yesterday and still can’t get the trigger to load on the Birthday flow.  Does anyone have any other ideas?  I’ve spent a lot of time on this and so far little progress!  Thanks. Sally

Hello @SallyB,

Welcome to the Klaviyo Community!

After reconfiguring the date property are you also including a year so the full date property reads MM/DD/YYYY instead of just MM/DD?

If you are not including a year, this would explain why you’re still not seeing that property as a date trigger option. In order for a property to be recognized as a date format, they’ll need to be in one of the formats mentioned in our Acceptable date and timestamp formats for profile and event properties reference Help Center article:

See the example below for information around formatting your date and timestamps in a CSV file. Note that, you must format dates as either YYYY-MM-DD or MM/DD/YYYY. If there's no time of day associated with your date, you can set it to midnight by using the HH:MM:SS value 00:00:00.

If you do not include seconds on your timestamps they will default to 0. For example, a timestamp of 2014-09-30 13:34 would be submitted to Klaviyo as 2014-09-30 13:34:00

For example, the date September 30, 2014, at 1:34:08 pm should be formatted using one of the following supported formats:

2014-09-30 13:34:08

2014-09-30 13:34:08+00:00

09/30/2014 13:34:08

09/30/14 13:34:08

09/30/2014 13:34

09/30/14 13:34

2014-09-30T13:34:08

2014-09-30 13:34:08.000001

2014-09-30T13:34:08.000001

2014-09-30 13:34:08.000001-04:00

1412098448 (Unix)

I would also suggest taking a look at some past Community posts on this subject. I’ve included some below that I think would be helpful to read through:

I hope this helps!

David


Reply