Hi team,
We have a requirement of importing data into schema with the help of workflow where the data is coming in .csv file format.
For one of the date field, we are receiving the format as "yyyy-mm-ddThh:mm:ss+0100". But we have to convert the time and date into iso format like "dd/mm/yyyy hh:mm:ss" and need to import into schema.
Can anyone please help in conversion of above date and time formats.
Thanks,
Raviteja.
Solved! Go to Solution.
Hi, the problem is not really as converting date format itself but more if the incoming format is understood by AC as a regular date time:
formatDate function is only for string conversion format... But, whatever the date format is, as long as AC understand it as a date, you can save it in a dateTime attribute schema without any issue.
The way it will be rendered by default in the nl console client depends of the DB preferences.
Once, in your schema's date time attribute, you can render the date as you want by converting it to a string with formatDate
You can find the answer in the following docs
https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html
https://blog.floriancourgey.com/2019/03/using-dates-in-adobe-campaign
logInfo(formatDate(getCurrentDate(), '%2D/%2M/%4Y %2H:%2N:%2S'))
Hi, the problem is not really as converting date format itself but more if the incoming format is understood by AC as a regular date time:
formatDate function is only for string conversion format... But, whatever the date format is, as long as AC understand it as a date, you can save it in a dateTime attribute schema without any issue.
The way it will be rendered by default in the nl console client depends of the DB preferences.
Once, in your schema's date time attribute, you can render the date as you want by converting it to a string with formatDate
Hi @ravitejagundu ,
I hope the following mat help.
1.import the the field a string in data loading workflow
2. in an enrichment activity add a new column of datetime type
3. Write an expression to convert the string to the new datetime field.
Cheers,
Deb
Hi Deb,
Can you please share the expression used in the enrichment activity for the date conversion?
Views
Replies
Total Likes
Hi @ravitejagundu,
Were you able to resolve this query with the help of any of the given solutions or do you still need more help here? Do let us know.
Thanks!
Views
Replies
Total Likes
Views
Likes
Replies