The Year field with value '2023-05-12' in '2023-05-12 18:09:07.825146' is too long

[god_prophet]

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.

[ParthaSarathy · Accepted solution]

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.

[god_prophet]

Hi @ParthaSarathy , how do you get to this screen? 

[ParthaSarathy]

@god_prophet ,

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.