Sort Portal by Timestamp Field

[nandito]

Hi Gang,

I have a portal which I have to sort by a Timestammps field. This field is automatically populutaed at some point by using the get(timestamp) function. Now when I look at the portal which should be sorted chronologically the dates are sorted like this:

6/8/2007 xx:xx AM

6/7/2007 xx:xx PM

6/2/2007 xx:xx AM

6/12/2007 xx:xx PM

6/1/2007 xx:xx AM

(my system uses the American date format of mm/dd/yyyy)

The 6/12 date should be first but it's next to the 6/1.

Is there a way to correctly sort chronologically?

Thanks guys.

Hernandito

[mr_vodka]

Double click the portal in layout mode. There will be an option to srot by field Asc or Desc

[nandito]

Thanks John, I did this from the begining but it still mis-sorts as I indicated in my post.

[comment]

Are you sure the field's type is Timestamp, not Text?

[nandito]

That was the problem!! It was a text field. Now that I changed it to a Timestamp field, it sorts correctly. I am embarrassed for missing this. I really apreciate your help.