5 Replies Latest reply: Dec 5, 2010 10:26 AM by martinohlson RSS

    Make a calendar with month year (Nov 2010, Dec 2010, Jan 2011 etc).

    martinohlson

      Hi,

      I want to create a calendar that uses the format MMM YY, so each calendar post contains both month and year.

      For the moment I can create a month calendar or a year calendar, but once i add these two together the posts get all unsorted.

      What i want to reach is a calender like this:

      Nov 10, Dec 10, Jan 11, Feb 11 etc.

      I thought i might use Year(OrderDate) & Month(OrderDate) AS OrderMonthYear, but the result is unsorted and I have not found a way to sort my calendar. It either sorts it by letters (putting April first) or by month disregarding year (putting Dec 10 and Dec 11 next to each other).