[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Sort by Date European Format
On Mon, Nov 19, 2001 at 10:36:21PM +0000, joachim.richter 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 ?
>
> thanx JoE
Some databases will do it automatically. Otherwise, why not just create a
YYYYMMDD field on which to sort?
>
>
>
> [search-region more=1 search="
>
> se=
> sf=xeingdatum
> op=ne
>
> co=1
> st=sql
> fi=products
> ml=20
> tf=xeingdatum
> 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]
>
> 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
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users