[Closed]date type in the crosstab

[otsizh]

Is it posible to insert the item of the date type inthe measures part of the crosstab?

When I do that it displayed as 20,051,231 insted of 12/31/2005
I applied data formating but it still is not working.

Thanks, Olha

[CoginAustin]

A date isn't really a measure is it?

I think it need to be numerical. You need to be able to sum/count and whatever else. How can you sum a date?

[sir_jeroen]

cross tab can't handle text :S

[sir_jeroen]

Little reminder: close the topic if it's been solved/closed (see board rules)