The field 'Month' with value '2023-07-11' in '2023-07-11' is too long. Maximum of 2 characters. Why am I getting this error? | Community
Skip to main content
August 7, 2023
Solved

The field 'Month' with value '2023-07-11' in '2023-07-11' is too long. Maximum of 2 characters. Why am I getting this error?

  • August 7, 2023
  • 2 replies
  • 764 views

When I put the date in the mm/dd/yyyy in the data type text its working properly but when I reupload the later date type yyyy-mm-dd its throwing the error as "The field 'Month' with value '2023-07-11' in '2023-07-11' is too long. Maximum of 2 characters." Why am I getting this error?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @debasmita17 ,

Are you using Load file activity to upload the file? If so, After uploading the sample file, in 'Column Definition' select the date field > edit property > and modify the date format as 'yyyy-mm-dd'

Refer Column definition Document

 

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
August 7, 2023

Hi @debasmita17 ,

Are you using Load file activity to upload the file? If so, After uploading the sample file, in 'Column Definition' select the date field > edit property > and modify the date format as 'yyyy-mm-dd'

Refer Column definition Document

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Sukrity_Wadhwa
Community Manager
Community Manager
August 24, 2023

Hi @debasmita17,

Was the given solution by @parthasarathy helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

Sukrity Wadhwa