Monthname range selection

[#1]

Hello all,

I have an invoice date where I convert it to monthname for charting etc.

When I use it in a list box, my user can of course select it using shift/ctrl. However if they want to select it using a range, specifiying something like:

>=Mar 2009<=Apr 2010

does not work. This I guess is because monthname creates a 'dual' value where the underlying values are numeric. This can be seen by creating another numeric field in the script then using the numeric value in the month search. It would be unreasonable to expect the user to do this though!

How do I achieve this?

Regards,

Gordon

[Anonymous · Accepted solution]

Gordon,
It should work if you use dates which are numereic, formatted as month names:
date(monthstart(datefield), 'MMM YYYY') as "Month Name"

[#3]

Hi Gordon

You can change the number format for MonthYaer to Date and MMM YYYY

Regards

Anders

[#4]

Thanks Michael and Anders,

Both solutions work!

Regards,

Gordon