Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sort order

Status
Not open for further replies.

pandy1

Programmer
Oct 9, 2002
52
US
Hi,

I want to sort my date field by time earliest..ie., 7 am , 8 am, 12 pm etc.,any ideas?

thanks
 
pandy1,

In crystal vers 8.5 (I'm not familar with other versions) there is a "Time" function that will return the time portion of a date_time field. You could use this function in a formula field, then sort on the formula field.

Time(mydate_timefield)

hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top