Date format not applied on crosstab report

[ninjamayo]

I have a crosstab report with two columns of dates (attributes) and I have calculations of min, max on them. I have tried everything to set the correct format on those two columns but I cannot get a short date shown. I have changed the aggregation / rollup aggregation to all sorts of different settings, I have done the calculation manually by using min and max, and I have set the date format within the data section of my columns. For some bizarre reason the dates are always displayed like this example: 20160516 and never as 16/05/2016 as I want them to be.

Any idea of what is going wrong?

[MFGF]

I have a crosstab report with two columns of dates (attributes) and I have calculations of min, max on them. I have tried everything to set the correct format on those two columns but I cannot get a short date shown. I have changed the aggregation / rollup aggregation to all sorts of different settings, I have done the calculation manually by using min and max, and I have set the date format within the data section of my columns. For some bizarre reason the dates are always displayed like this example: 20160516 and never as 16/05/2016 as I want them to be.

Any idea of what is going wrong?

Are you using a dimensional package or a relational package?

MF.

[bdbits]

Are they actually stored as dates in your data source? Could they actually be strings representing dates?

[dougp]

20160516 appears to be an 8-digit integer representation of a date, not actually a date.

If your data is actually a date data type (coming out of the Framework Manager model) the format will be whatever your default date format is.

[ninjamayo]

It seems that we were looking at the aggregations completely the wrong way. Problem solved now. Basically we needed to add the dates as rows to our crosstab.