thanks for the quick reply. Used the following import script according to your proposal:
Date#(B,'MMMM YYYY') as Datefield,
A is the department, B in this case is the field with the date "January 2011", C blah, blah,
The import works fine - the box is named Datefield, but the months still show up in a wrong order, ie. February, January, March. Is there something else I need to do in the settings somwhere?
So far I d not get ahead...
The list box is still not listed correctly nor does the field work anymore as it was intended i.e. clicking on a month should bring only the activities in this month.
The import string looks like this now: LOAD
Date#([Revenue month],'MMMM YYYY')as Revenue_month,
As I was able to get also one separate field with the month number (sorted correctly) I think it might be easier to show these numbers as written month name. How would this work?