[ic] sort by date for europe

[Stefan Hornburg Racke]

"joachim.richter" <joachim.richter@usvideocenter.de> writes:

> Hi list,
>  
>  has anybody ever come across the european Date format which is DD.MM.YYYY (Day/Month/Year) ?
>   I am trying to make a list that search articles by the date in the xeingdatum column,
>  articles with empty xeingdatum fields will be filtered out, but the following search
>  does not give any satisfying result. 
>  
> Since the 31.03.2000 will come before the 30.11.2000, does anybody have any experience with this ?
> 
> We are using Interchange 4.8 and a mysql database, plus i am also trying to get the mm (max matches) to work on this
> 
> What I am actually trying to do is, a list with the latest 25 articles sorted by date.

MySQL's default format is YYYY-MM-DD, which can be pretty good sorted
without any additional measures.

Ciao
        Racke

-- 
Die Erde bleibt keine Scheibe. --- The earth remains no disk.

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)