Expand my Community achievements bar.

SOLVED

Date and Time format in Adobe Campaign when importing CSV file

Avatar

Level 3

Dear community

 

I am trying to import csv data into Adobe Campaign. However one of my column (Time Of Sales) is a date+time format. In my csv file (Purchase date), is a date format. I tried to change the format to Date and Time in the csv file but there are no available options that matches the format in Adobe Campaign therefore the data did not get imported through. Please guide me to how I could resolve this issue. The image are attached below.

 

Kind regards

Sching 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @ChanuteJo ,

Define Data type as 'date' and format as dd/mm/yyyy in data loading activity.

Place a enrichment next to it, and add an expression ToDateTime(date_attribute_from_file) and use this field to update in databade.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @ChanuteJo ,

Define Data type as 'date' and format as dd/mm/yyyy in data loading activity.

Place a enrichment next to it, and add an expression ToDateTime(date_attribute_from_file) and use this field to update in databade.