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.
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @ogonzalesdiaz ,
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.
Hi @ogonzalesdiaz ,
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.
Views
Replies
Total Likes
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.