[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] sort by date for europe
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
===============================================================
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users