Dear all users of this newsgroup,
The product team here in redmond needs your help to find out usage patterns
of the following format string token.
This is very important for us to better understand which ones are often or
seldom used.

Format string can be set for Measures, calculated members, calculated cells,
custom member formulas...
Please take a few seconds to respond to this post mentioning which of the
following tokens you ever used in a custom format string.

Token for string values:

@ = character placeholder. Displays a character or a space.

& = character placeholder. Displays a character or nothing.

< = forces lowercase.

! = forces left to right fill of placeholders.



Tokens for date/times:

w = day of week (1-7)

ww = week of year (1-54)

q = quarter of year (1-4)

y = day of year (1-366)

n = minute as a number without leading zeros (0-59)

nn = minute as a number with leading zeros (00-59)

AM/PM, am/pm, A/P, a/p, AMPM - these basically give the same thing with
different case for the time AM or PM qualifier.

Thanks a lot for your help.

Thierry D'hers

Lead Program Manager

SQLBI Program Management

425 705 5471

Mailto:tdhers (AT) microsoft (DOT) com

Microsoft Corporation

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

never used the string tokens.... in the end, we used vba/excel formulae for
string formats (even though we could have obviously used these.

used the date and tokens - but rarely... given that most measures seldom
equate to date and time values, these are not as useful as the different
tokens used for setting the formats of numbers.

"Thierry D'hers" <tdhers (AT) microsoft (DOT) com> wrote

I've used the time tokens to display calculated call-related times in a
user-familiar format like "hh:nn:ss".


- Deepak

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!