Select broken years

[#1]

I present Year and Month apart from each other in two list boxes. How do I select a broken year, such as November 2012 till Oktober 2013? 

Now I see January till December for the years 2012 and 2013.

[#2 · Accepted solution]

Hello,

You can achieve this by adding in your script a field (as MonthYear) that combines both of Year and Month together like this:

LOAD Year,

Month,

Month & '-' & Year as MonthYear,

etc...

Or if you have the actual date you can do this:

LOAD TrxDate,

Year(TrxDate) as Year,

Month(TrxDate) as Month,

Date(MonthStart(TrxDate), 'MMM-YYYY') as MonthYear

etc...

Then simply use that MonthYear field as a listbox.

Hope this helps.

[Or]

Monthname(TrxDate) does the trick quite nicely.