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

Avatar

Avatar

raphael_nottebo

Avatar

raphael_nottebo

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

Avatar

Avatar

Megpeg2013

Avatar

Megpeg2013

Megpeg2013

08-08-2013

Same with ReportBuilder!!

Avatar

Avatar

Gigazelle

Employee

Avatar

Gigazelle

Employee

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!