New Report Builder: Can you Change Date Format?

Question

Hi everyone, I hope you are well and having a good week.
I have recently started using the newer Adobe Analytics Report Builder. My question is, is it possible to change the date format when using the "Days" dimension?

The "Days" dimension appears to default to "YYYY/MM/DD". It was possible to change this in the old Report Builder (for example to "DD/MM/YYYY") using the "format" functionality, but I cannot see this option in the new Report Builder. I can make the change using Excel's formatting once the report has run, but each time the request updates, the formatting seems to revert back.

Does anyone know if it is possible to alter date formats in the new Report Builder or, if not, if it is expected in the future?

Jennifer_Dungan · Accepted Answer

I used to have that issue with the old report builder sometimes too...

Generally, I don't worry about formatting the "raw" data our Report Builder... rather, I usually keep the "raw data" (i.e. the sheets that are generated by Report Builder) as hidden sheets, then I create my "clean" sheets... this is where I display the data in the final format, with the data and data formats that I want.

Basically I use Excel cell referencing to pull the data from the "raw data" sheets.

This way, it shouldn't matter if Report Builder has "YYYY/MM/DD", because in your clean sheet, you have full control over the date format and that won't change because the cells aren't actually being overwritten.

I get that it's a little more work, but its a lot easier than trying to fight with the default.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded