Conversion of date and time format yyyy-mm-ddThh:mm:ss:sss to dd/mm/yyyy hh:mm:ss

[ravitejagundu]

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.

[david--garcia]

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'))

[LaurentLam · Accepted 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 

[Deb_Tripathy]

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

[kishoram]

Hi Deb,

Can you please share the expression used in the enrichment activity for the date conversion?

[Sukrity_Wadhwa]

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!