Hi all,

I have a time dimension which has a date field (Analysis
Server returns Date). I would like to change the display
format of the date with respect to the client machine.
Like a machine with "united kingdom settings" the date
should be shown "23/01/2003" and for a machine
with "united states settings" the date should be
shown "01/23/2003".

My basic question is how does one support different date
formats (for a date in time dimension)? I use EXCEL XP
and Analysis Server. changing the format in Excel doesnt
with Dimension fields.

Thanks for any input/suggestions.