error message: "SMS consent date" for one column of data that isn't in the yyyy-mm-dd format

FirstNameL649218
Rookie
0 Votes

my Excel spreadsheet is in that format and I have tried other formats also. Any suggestions?

1 REPLY 1
William_A
Administrator
0 Votes

Hello @FirstNameL649218 ,

 

I'd advise calling general support, so they can take a look at the list's formatting and help with getting it imported for you live.

 

If you're unable to call, please reply directly to the automated @ mention email you receive from this response. In the reply email, please include your account username and attach the contact file. The file will need to at least include the email address of the contact, their SMS number, and the SMS consent date in the yyyy-mm-dd format. 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
JAN 06
How to Grow Your List in Constant Contact
3PM - 4PM EST