Jump to content
Salesforce and other SMB Solutions are coming soon. ×

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


furbies
 Share

Recommended Posts

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 by furbies
elucidation
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use