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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Change Date Format to something that can be recognised by Excel

Avatar

Avatar
Boost 25
Level 3
timr98608316
Level 3

Likes

25 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 25
Level 3
timr98608316
Level 3

Likes

25 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 25
Boost 5
Boost 3
Boost 10
Boost 1
View profile
timr98608316
Level 3

27-11-2011

Currently, when running reports at a 'daily' granularity, the date format when downloaded (into .csv or .excel) appears as e.g. "Nov  1, 2011".

This format is very problematic when dealing with reports in Excel and always requires a transformation.  It should instead be populated in a format that Excel could recognise as a date.

This is particularly an issue when extracting Data Warehouse reports, where one is likely to have many rows per single date and it is therefore more time-consuming to transform into actual dates.

Thanks,

Tim.

2 Comments

Avatar

Avatar
Affirm 500
Employee
Gigazelle
Employee

Likes

479 likes

Total Posts

1,949 posts

Correct reply

740 solutions
Top badges earned
Affirm 500
Applaud 500
Give Back 1000
Ignite 90
Coach
View profile

Avatar
Affirm 500
Employee
Gigazelle
Employee

Likes

479 likes

Total Posts

1,949 posts

Correct reply

740 solutions
Top badges earned
Affirm 500
Applaud 500
Give Back 1000
Ignite 90
Coach
View profile
Gigazelle
Employee

08-03-2018

This idea is duplicated by Change the date format in Data Warehouse and ReportBuilder so Excel can easily manage​​, adding an additional 5 votes here.

Avatar

Avatar
Give Back
Level 1
floriana_guardi
Level 1

Likes

0 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Give Back
Applaud 5
View profile

Avatar
Give Back
Level 1
floriana_guardi
Level 1

Likes

0 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Give Back
Applaud 5
View profile
floriana_guardi
Level 1

04-09-2019

Hi Gigazelle​,

This request is marked as delivered, but it specifically mentioned Data Warehouse and it seems like the new admin setting has no impact on Data Warehouse exports. Any chance this might be reopened and the issue with DW export addressed?

Best,

Floriana