Skip to main content
Contributor I
May 5, 2023
Solved

Birthday Flow Trigger Not Coming Up As Trigger

  • May 5, 2023
  • 1 reply
  • 247 views

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

    This topic has been closed for replies.
    Best answer by David To

    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

    1 reply

    David To
    Klaviyo Employee
    David ToAnswer
    Klaviyo Employee
    May 5, 2023

    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