New Report Builder: Can you Change Date Format?

[tcrewes1]

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]

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.

[MandyGeorge]

I second Jen's opinion, I've done the same thing. 

Have a sheet (or multiple sheets if needed) where you pull all of the "raw" data. And then have a "good" sheet (or sheets) that references the raw data, that way you can set the cell types and not have to worry about them being overwritten on each new data pull.