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

Change the date format in Data Warehouse and ReportBuilder so Excel can easily manage.

Avatar

Avatar
Validate 1
Level 2
raphael_nottebo
Level 2

Likes

14 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Validate 1
Level 2
raphael_nottebo
Level 2

Likes

14 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
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
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
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!