Skip to main content
Solved

Birthday Flow Date property

  • 31 March 2023
  • 1 reply
  • 363 views

Forum|alt.badge.img+2

Hi everyone,

I am planning to generate a birthday flow, but I got stuck in the very first step (choosing the trigger), although based on what I found on Klaviyo support I changed the date format to YYYY.MM.DD, the birthday date is still not shown as a custom property to me, so I cannot go forward with the flow.

That would be really helpful if you can give me any suggestions on how to fix it.

Best answer by stephen.trumble

Hey @Della 

Welcome to the community and congrats on your first post! Happy to help with your formatting for dates!

See the example below for information around formatting your date and timestamps in a CSV file or API call. You must format dates as either YYYY-MM-DD or MM/DD/YYYY. Note that dates cannot be formatted in the DD-MM-YYYY format. Also using “ . “ to separate year, month and date will not accurately update in Klaviyo. 

One question, how are the birthdates being added to a profile? Through CSV upload? Sign-up form? If you are uploading via CSV file, make sure you are mapping the birthday data as a Date property. If you have already mapped this as anything other than a date (ie Text) , you will need to purge all profile data containing this property and reupload with the correct mapping or create a net new property that is mapped as a date, 

Hope this helps!

 

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

stephen.trumble
Community Manager
Forum|alt.badge.img+60
  • Community Manager
  • 1513 replies
  • Answer
  • March 31, 2023

Hey @Della 

Welcome to the community and congrats on your first post! Happy to help with your formatting for dates!

See the example below for information around formatting your date and timestamps in a CSV file or API call. You must format dates as either YYYY-MM-DD or MM/DD/YYYY. Note that dates cannot be formatted in the DD-MM-YYYY format. Also using “ . “ to separate year, month and date will not accurately update in Klaviyo. 

One question, how are the birthdates being added to a profile? Through CSV upload? Sign-up form? If you are uploading via CSV file, make sure you are mapping the birthday data as a Date property. If you have already mapped this as anything other than a date (ie Text) , you will need to purge all profile data containing this property and reupload with the correct mapping or create a net new property that is mapped as a date, 

Hope this helps!