Inconsistent date format in data warehouse reports

[hemanthn3230019]

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

[Pablo_Childe]

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

[Urs_Boller · Accepted solution]

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 ...

[hemanthn3230019]

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

[hemanthn3230019]

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

[Urs_Boller]

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