[ic] Sort by Date European Format

[interchange-users@interchange.redhat.com]

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