Change the date format in Data Warehouse and ReportBuilder so Excel can easily manage. | Community
Skip to main content
Level 2
Aug 5, 2013 9:46 PM UTC
Declined

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

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 replies

Gigazelle
Employee
Mar 8, 2018 10:45 PM UTC

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

Translate
Level 2
Aug 8, 2013 7:18 AM UTC

Same with ReportBuilder!!

Translate