J
Jelle
LS,
query below is sorted on order and date ascending. The date fields are, as
far as I know real date fields, still, the sort appears to be alphanumeric,
which screws up a min max on the query as well.
Any suggestions??
ID UNIQUE_KEY ORDER Assignment aanmaak Assignment
31229 33238020 NH38650 03/05/2008 8:57:17 03/05/2008 10:41:43
31210 33237654 NH38650 03/05/2008 8:57:17 03/05/2008 9:23:00
31221 33237778 NH38650 03/05/2008 8:57:17 03/05/2008 9:37:34
query below is sorted on order and date ascending. The date fields are, as
far as I know real date fields, still, the sort appears to be alphanumeric,
which screws up a min max on the query as well.
Any suggestions??
ID UNIQUE_KEY ORDER Assignment aanmaak Assignment
31229 33238020 NH38650 03/05/2008 8:57:17 03/05/2008 10:41:43
31210 33237654 NH38650 03/05/2008 8:57:17 03/05/2008 9:23:00
31221 33237778 NH38650 03/05/2008 8:57:17 03/05/2008 9:37:34