Inconsistent date format in data warehouse reports

Avatar

Avatar

hemanthn3230019

Avatar

hemanthn3230019

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)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
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)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

09-01-2019

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

Avatar

Avatar

hemanthn3230019

Avatar

hemanthn3230019

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

Avatar

Avatar

hemanthn3230019

Avatar

hemanthn3230019

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

Avatar

Avatar

pabloc82923542

Avatar

pabloc82923542

pabloc82923542

08-01-2019

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