Enter the Share Your Success Sweepstakes 2024 For the Chance to Win Great Prizes!

Importing birthdays

SOLVED
Go to solution
MeganR9766
Rookie

I have a large list of customers who already have their birthdays listed with their profile. I'm trying to import these customers into contact contact and it keeps saying the birthdays are not in the correct 'birthday format'. Does anyone know the correct date format CC will allow?

1 ACCEPTED SOLUTION
William_A
Administrator
0 Votes

Hello @MeganR9766 ,

 

The following are the accepted formats for Birthdates when importing contacts via file:

MM/DD/YYYY   DD-Month   YYYY-MM-DD
M/D/YYYY   D-Month   YYYY-M-D
YYYY/MM/DD   DD-Month-YY  
YYYY/M/D  

 

Some other important notes:

  • If using Excel to edit and manage the file, the field should be formatted as "Date" or "Custom."
  • After import, the date in a contact record appears as "Month, Day." We don't store the year.

For more info, please see our article on standard headings and character limits for contact fields, also available via the Help tab in your account. 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

View solution in original post

1 REPLY 1
William_A
Administrator
0 Votes

Hello @MeganR9766 ,

 

The following are the accepted formats for Birthdates when importing contacts via file:

MM/DD/YYYY   DD-Month   YYYY-MM-DD
M/D/YYYY   D-Month   YYYY-M-D
YYYY/MM/DD   DD-Month-YY  
YYYY/M/D  

 

Some other important notes:

  • If using Excel to edit and manage the file, the field should be formatted as "Date" or "Custom."
  • After import, the date in a contact record appears as "Month, Day." We don't store the year.

For more info, please see our article on standard headings and character limits for contact fields, also available via the Help tab in your account. 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
  • Avatar

    Featured Article

    Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

    Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.

    See Article
  • Avatar

    Featured Thread

    Casual Conversations: What's your go-to playlist?

    If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!

    View thread
  • Avatar

    Featured Thread

    Share Your Success Sweepstakes

    Share a success story from the last year and be entered for a chance to win great prizes!

    Enter now!
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
DEC 12
Ask Us Anything: Your Digital Marketing Questions Answered
2PM - 3PM EST