12 Replies Latest reply on Jan 18, 2013 1:46 PM by Anne Jenkins

    Format a date as MYY (e.g., D11, J12) or even M

      I've got limited real estate on a screen, and as such would like to display dates on the x-axis with as few digits as possible.

       

      For a rolling 13-months, ideally this would be 1-character - D J F M A M J J A S O N D J.

       

      While a calculated field can be created with the 1st character of the month, this (not surprisingly) causes the four months that start with 'J' to be rolled-up. Inserting another "hidden" variable with the full month (yyyymm) above the calculated field fixes this problems, but then a line can't span the cells (at least I couldn't figure out how to do so!).

       

      Any thoughts on how to get around this (e.g., custom format that I'm not figuring out), or is something like YY-MM the best I can do for a short month abbreviation?

       

      Thanks!