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

    Ted Conway

      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?