Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Deivit]

Hi,

I'm having a hard time trying to get an advanced expression to sort correctly.

I've set up a view scheme that uses an advanced expression for the "month" imported. In panes view, the months appear in spanish (I assume that the expression uses some windows standards) but sorts them in alphabetical order:

Abril
Agosto
Diciembre
Enero
Febrero
Julio
...

I checked the following expressions, all of them to no avail:

FormatDate([Date Imported,0], month)
FormatDate([Date Imported,0], MMMM)&DataType=[Month]

Even with the expression set to:
FormatDate([Date Imported,0], MM)&DataType=[Month]

the month appears in figures (01, 02, 03, 04, etc.) but sorted according to the spanish translation of the month... (04, 08, 12, 01...)

Is this a bug or am I doing something wrong?

Thanks for your time.

[Matt]

Sorry, but the sort engine currently only understands months in English.

[Deivit]

Thanks for the info, Matt. I was actually surprised when I saw that the months were in spanish.

Is there any way that I could use the months in english? or use the 2 digits of the month (01, 02, etc.)and get them sorted properly? or am I stuck to get it unsorted because my windows version is in spanish? 

Thanks again.

------
Listening to: 'You Speak My Language' from 'Blender' by 'Collective Soul' on Media Center 11

[Deivit]

Ok, I figured it out 

The expression
FormatDate([Date Imported,0], MM)

put the months in the two-digit format and sorted them correctly (01, 02, ...12)

Not as neat as with the name of the months, but it works.

Thank you.