Date and Time format in Adobe Campaign when importing CSV file

[ChanuteJo]

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 

[ParthaSarathy · Accepted solution]

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.