Filtering dates by Month

[ECEK]

My underlying query has a Mydate field.
User wants to see both the date and the written month name.
I duplicated the date field and set the Format in the property of the field to "mmmm" all fine.

However this new "month" field does not filter correctly in the datasheet form and still filters on the specific date.

I then used:

Month: Format([Mydate],"mmmm")

This has sorted my problem with regarding the correct filtering.

My question is that in the filtering drop down, the months are in alphabetical and not Month order.

Is there a way to correct this?

 

[Minty]

Add a hidden field to your combo Month(MyDate), and sort on that.

Edit : I would call your formated "mmmm" field something other than Month to avoid confusion - it's a reserved word(obviously)

 

[missinglinq]

...My question is that in the filtering drop down, the months are in alphabetical and not Month order...

The reason for this is that the Format Function always returns a String, no matter what the Datatype of the formatted Field is...hence the Alphabetical sorting of it.

Linq ;0)>