Date and Time format in Adobe Campaign when importing CSV file | Community
Skip to main content
C
ChanuteJo
Level 3
August 16, 2024
Solved

Date and Time format in Adobe Campaign when importing CSV file

  • August 16, 2024
  • 1 reply
  • 901 views

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.
Best answer by ParthaSarathy

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.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
August 16, 2024

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~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...