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

raphael_nottebo

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 (2 New)
2 Comments

Megpeg2013

08-08-2013

Same with ReportBuilder!!

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!