• Constant Contact Logo

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

FirstNameL649218
Participant
‎05-09-2023 04:04 PM
‎05-09-2023 04:04 PM
my Excel spreadsheet is in that format and I have tried other formats also. Any suggestions?
0 Votes
1 REPLY 1
William_A
Administrator
Administrator
‎05-09-2023 04:13 PM
‎05-09-2023 04:13 PM

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
0 Votes
  • Avatar

    Support Tips

    Social Media

    "There's a multitude of ways to engage your audience through us using your social platforms - via ads, social post metrics, email links, and more! " - Will

    See Article
  • Avatar

    Support Tips

    Call-To-Action Links

    "Target your most engaged contacts by creating a segment. Create a special offer or show your appreciation!" - Caitlin

    See Article
  • Avatar

    Support Tips

    Welcome Your Audience

    "Greet new contacts with one or more automated Welcome Emails depending on their interests or your business goals." - Nick

    See Article