Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Inconsistent date format in data warehouse reports

Avatar

Avatar
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
hemanthn3230019
Level 1

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
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
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
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
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
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
hemanthn3230019
Level 1

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
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
hemanthn3230019
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
hemanthn3230019
Level 1

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
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

08-01-2019

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