time sort

[GlennC]

Hello,

I have imported data which includes a 12-hour time field. The imported data is not referenced as am or pm, but they refer to business hours, so the times always refer to 9am ... 6pm. I want to sort these into correct chronological order. Sorting ascending puts am times like 10...11...12 at the end of the list. I don't want to work with 24-hour time. Is there a way aorund this?

[kennedy]

Create a second field with 24 hour time OR proper am/pm designator, and then create your sort on the 24 hour time OR on am/pm followed by 12 hour time.

You can sort on fields that you do not display. And those hidden sort fields can be simple calculations from your time field such that your user never needs to know their there... unless they are building custom sorts.

[GlennC]

thanks Kennedy, that's works just fine!