Inconsistent date format in data warehouse reports | Community
Skip to main content
H
hemanthn3230019
New Participant
January 8, 2019
Solved

Inconsistent date format in data warehouse reports

  • January 8, 2019
  • 5 replies
  • 1946 views

Hi Team,

I have scheduled few Adobe data warehouse reports with daily granularity in CSV format. I receive the CSV files with inconsistent date format for the date column.

Can you let me know the reasons for inconsistent date format for date column and how can i overcome it.

Thanks in Advance.

Regards,

Hemanth

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 Urs_Boller

maybe this setting helps:

in Analytics go to "Admin" -> "Company Settings Home" -> "Preferences"

there you have an option to change date format to "ISO 8601" which can be used in all apps I know ...

5 replies

Urs_Boller
Urs_Boller
New Participant
January 9, 2019

in which schedules/CSV do you have another date format as expected? sounds like a bug and might be reported to CC...

H
hemanthn3230019Author
New Participant
January 9, 2019

Hi,

I too have read about this and "Use Deprecated Date format for CSV (Jan 8, 2019)" option is selected in my case which is the default one.

The issue is most of the files have the date format as expected which is January 1, 2018.

Only for few files i see the date format as 1/1/2018.

We have written an automated job and it is failing since few files have inconsistent date format.

Regards,

Hemanth

H
hemanthn3230019Author
New Participant
January 9, 2019

Hi,

I was expecting the file to contain this format - January 1, 2018.

Most of the files contain above format only, only around 5-10 files contain the format - 1/1/2018.

We would like to write an automated job and it is failing since few files have inconsistent date format.

Regards,

Hemanth

Urs_Boller
Urs_BollerAccepted solution
New Participant
January 8, 2019

maybe this setting helps:

in Analytics go to "Admin" -> "Company Settings Home" -> "Preferences"

there you have an option to change date format to "ISO 8601" which can be used in all apps I know ...

    Pablo_Childe
    Pablo_Childe
    New Participant
    January 8, 2019

    Any chance you paste what it looks like? (anonymize sensitive data if applicable)

    Terms & ConditionsAccessibility statement

    Loading footer...