ok now i have another problem...

it does order correctly to a certain degree

i have changed the order to a different field now which is an alt date which is put in to a field and subbmited via a form

trouble is the dates get mixed up.

if i have 1,5,2012 in one record
13,5,2012 in the second record
and 1,6,2012 in the third record

1,6,2012 will display as the second record on the table i have which is not what i need becase 1,6,2012 is after 13,5,2012

if you refer to my screenshot for a better description
http://www.chulse.co.uk/date-error.png

you can see friday `1, june 2012 is the 2nd row down which should be the last row. It is not ordering from this date it is ordering from a hidden date which is the same just in a different format. dateFormat: 'd-m-y',

how would i go about getting this in the right order?

Thanks