Conversion of date and time format yyyy-mm-ddThh:mm:ss:sss to dd/mm/yyyy hh:mm:ss | Community
Skip to main content
ravitejagundu
ravitejagundu
Level 3
September 22, 2021
Solved

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

  • September 22, 2021
  • 4 replies
  • 8565 views

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.

    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 LaurentLam

    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 

    4 replies

    david--garcia
    david--garcia
    Level 10
    September 22, 2021

    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
      LaurentLamAccepted solution
      Level 5
      September 26, 2021

      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 

        D
        DebTr
        Level 6
        September 27, 2021

        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

          K
          kishoram
          May 26, 2023

          Hi Deb,

           

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

          Sukrity_Wadhwa
          Community Manager
          Sukrity_WadhwaCommunity Manager
          Community Manager
          October 6, 2021

          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!

          Sukrity Wadhwa
          Terms & ConditionsAccessibility statement

          Loading footer...