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 the date format in Data Warehouse and ReportBuilder so Excel can easily manage.

Avatar

Avatar
Give Back
Level 2
raphael_nottebo
Level 2

Likes

15 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 5
Boost 3
View profile

Avatar
Give Back
Level 2
raphael_nottebo
Level 2

Likes

15 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 5
Boost 3
View profile
raphael_nottebo
Level 2

05-08-2013

don't use July 1, 2013 but 1/7/2013

then it's just about using the DATAVALUE() function to transform text into dates. The function can only deal with dd/mm/yyyy dates.

Thanks!

Raphael

2 Comments

Avatar

Avatar
Boost 5
Level 3
Megpeg2013
Level 3

Likes

34 likes

Total Posts

6 posts

Correct reply

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

Avatar
Boost 5
Level 3
Megpeg2013
Level 3

Likes

34 likes

Total Posts

6 posts

Correct reply

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

08-08-2013

Same with ReportBuilder!!

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

Flagging as a duplicate of Change Date Format to something that can be recognised by Excel - show your support by upvoting there!