[ic] Sort by Date European Format

joachim.richter interchange-users@interchange.redhat.com
Mon Nov 19 16:36:01 2001


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



[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