[RESOLVED] How To Set Records Order According To This Kind of Field?

[DEXWERX]

1) Is this JET or MySQL ?
2) unless we're using a date type of field, all bets are off.

That suggests he's using MySQL. I don't recall off the top of my head how MySQL handles date delimiters, but I think using single quotes around it should be sufficient.
-tg

MySQL dates are passed as Strings in a certain format 'YYYY-mm-dd hh:nn:ss'. MySQL also likes to fail silently about failed date conversions, and just store zeros.