This conversation has been locked due to inactivity. Please create a new post.
Submissions are now open for the 2026 Adobe Experience Maker Awards
SOLVED
The Year field with value '2023-05-12' in '2023-05-12 18:09:07.825146' is too long
I don't have a column Year on my data, but I think it is taken the year from my column: "date_creation".
How can I remove the miliseconds from my column "date_creation" to avoid this warnings? Or Should I fix this in the source of the data? I get a csv file to upload to campaign.
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
Hi @god_prophet ,
For the date_creation column, in data loading activity configure the date+time format as below,
Run the workflow and check. Or If you are able to change the values in input file, you can handle there.
Or else you can try below approach as well,
In data Loading activity, instead of defining it as date+time, define it as 'string'.
Connect data loading transition with enrichment activity.
Enrichmet:
Add data > add an output column in it with below expression,
ToDateTime(date_creation)
Now the new field created in enrichment, will remove the millisecond.
Correct answer by
Hi @god_prophet ,
For the date_creation column, in data loading activity configure the date+time format as below,
Run the workflow and check. Or If you are able to change the values in input file, you can handle there.
Or else you can try below approach as well,
In data Loading activity, instead of defining it as date+time, define it as 'string'.
Connect data loading transition with enrichment activity.
Enrichmet:
Add data > add an output column in it with below expression,
ToDateTime(date_creation)
Now the new field created in enrichment, will remove the millisecond.
Data Loading activity > Click here to change the file format > double click your date column or select your date field and click details button on the right side.
Related Conversations
