How can I modify the Date format of output file created in a Destination? | Community
Skip to main content
Level 2
May 25, 2023
Solved

How can I modify the Date format of output file created in a Destination?

  • May 25, 2023
  • 2 replies
  • 1087 views

For example, when we output our segment to the Data Landing Zone the Date format is yyyy-mm-dd. Is it possible to change this date format in the output file to mm/dd/yyyy?

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 adobechat

Hi,

Adobe Experience Platform (AEP) do not have an out-of-the-box feature that allows you to change the date format in the output file directly from the user interface. The date format is set to be ISO-8601 (YYYY-MM-DD) and this is applied across the entire platform for consistency and standardization.

You would have to tackle it in post processing of data.

Thanks

Madhan

2 replies

AtulChavan
Community Advisor
Community Advisor
June 5, 2023

Hi @michaelbailey , to my knowledge unfortunately there is no such option as of now exists. All you can either have "YYYYMMDD_HHMMSS" or "10-digit Unix format". I'm hoping soon Adobe would add more formats into that list

adobechat
adobechatAccepted solution
Level 5
June 8, 2023

Hi,

Adobe Experience Platform (AEP) do not have an out-of-the-box feature that allows you to change the date format in the output file directly from the user interface. The date format is set to be ISO-8601 (YYYY-MM-DD) and this is applied across the entire platform for consistency and standardization.

You would have to tackle it in post processing of data.

Thanks

Madhan