Can visIntmMask be set to result in "2011Q3"?

Started by dmzasdf, May 22, 2011, 11:00:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

dmzasdf

It seems the date format for a timeline shape interval attribute is controlled by visIntmMask, but all I can mask is the year and the letter "Q", but not the quarter number. I have tried various masks used by various Microsoft products as well as every letter of the alphabet. I can't figure out whether Excel type formulas as allowed, but can't get them to work either. Any clues would be greatly appreciated.

Sincerely,
Dave Z

dmzasdf

In Excel, the formula could be: =TEXT(A1,"YYYY")&"Q"&ROUNDUP(MONTH(A1)/3,0)