Skip to main content
Level 3
Aug 16, 2024 6:26 AM UTC
Solved

Date and Time format in Adobe Campaign when importing CSV file

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 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Aug 16, 2024 8:06 AM UTC

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.

~  ParthaSarathy S

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Aug 16, 2024 8:06 AM UTC

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.

Translate
~  ParthaSarathy S