Date formatting in grid - AM/PM

I need to display time in US format
10/27/2006 10:12 AM
Is there a way to take the AM/PM part into account, so the sorting will work right?

does anyone know how to do that?

Use AW.Formats.Date:
http://www.activewidgets.com/aw.formats.date/

The current AW.Formats.Date class does not handle 12h time format. You have to manually patch textToValue method -

var date = new AW.Formats.Date;

date.textToValue = function(s){
    return Date.parse(s);
}