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?

[Debasmita17]

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?

[ParthaSarathy · Accepted solution]

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

[Sukrity_Wadhwa]

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!