[ic] sort by date for europe

[Ed LaFrance]

At 05:28 PM 11/27/2001 +0000, you wrote:
>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 ?

Yeah, and the answer is: don't try. Store your dates as YYYYMMDD, and use 
the [convert_date] tag to rearrange the digits for display in your search 
results.  Any other way leads to insanity.

- Ed L.


>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.
>
>[search-region more=1 search="
>
>                 se=             [blank - because I like to skip the empty 
> fields]
>                 sf=eurodate
>                 op=ne
>
>                 co=1
>                 st=sql
>                 fi=products
>                 mm=25
>                 tf=eurodate
>                 to=nr
>                 "]
>[search-list]
><TR>
>         <TD ALIGN=LEFT>[item-data products description]</TD>
>         <TD ALIGN=LEFT>[item-data products xeingdatum]</TD>
></TR>
>
>[/search-list]
><TR><TD COLSPAN=2><HR></TD></TR>[more-list]
><TR>
>         <TD>More</TD>
>         <TD COLSPAN=1>[more]</TD>
>         </TR>
>[/more-list]
>
>[/search-region]
>
>thanx JoE
>US Video Center Medien GmbH
>Heimsheimer Str 22
>70499 Stuttgart
>
>Tel 0711 880252 0
>Fax 0711 880252 22
>Email joachim.richter@usvideocenter.de
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================