Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

Adobe Analytics

Join us January 15th for an AMA with Champion Achaia Walton, who will be talking about her article on Event-Based Reporting and Measuring Content Groups!

RSVP Here

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

Level 2

8/5/13

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

Level 3

8/8/13

Same with ReportBuilder!!

Employee Advisor

3/8/18

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Related Conversations

Dynamic time range filters in CJA Workspace

Analysis Workspace - Dynamic "Previous Date Range"

Revamp Company Folder Administration and Behaviour

user group as the owner of workspaces and segments

Visitor level segment with rolling date range

133

Adobe Analytics

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

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe