Sorting on TimeStamp (Sort TimeStamp field purely on the time portion)

[furbies]

In my DB I have a TimeStamp field which covers a period of weeks. (and different times throughout the day of course)

 

I've been unable to figure out how to sort purely on the Time portion of the TimeStamp field. (Ignoring the date portion)

 

The only idea I've come up with is to create a second field that contains just the time portion (extracted from the TimeStamp field) of the TimeStamp field and sort on that.

 

Is this the best way to solve this or has anyone solved this by being able to just sort on the time portion of the TimeStamp ?

 

tia

 

furbies

Edited January 27, 2016 by furbies
elucidation

[AHunter3]

That's how I'd do it. New calculation field, result type "time", defined as GetAsTime (YourTimeStampField), then sort on that new calc field.\

[furbies]

That's how I'd do it. New calculation field, result type "time", defined as GetAsTime (YourTimeStampField), then sort on that new calc field.\

 

Thanks AHunter3

 

I've been away from FM for a while and what there is of my brain is very rusty when I try to remember FM stuff.

I did go with the separate field with the time portion of the TimeStamp and sort on that.