Inconsistent date format in data warehouse reports

hemanthn3230019

08-01-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

ursboller

MVP

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

Answers (4)

Answers (4)

hemanthn3230019

09-01-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

hemanthn3230019

09-01-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