Sorting Dates By Time Not Date

Posted on 2003-03-20
Medium Priority
Last Modified: 2013-12-18
I have a field that computes date -

@Text(@Now) - so I will get 03/20/2003 02:02:00 PM

In my view when I sort by assceding and categorized - it displays this

03/20/2003 02:02:00 PM
03/20/2003 08:02:00 AM
03/20/2003 11:28:00 AM

I think it is going off the date 03/20/2003 and does not see the time 02:02:00 PM  
Is there a way I can set up the view to display

03/20/2003 08:02:00 AM
03/20/2003 11:28:00 AM
03/20/2003 02:02:00 PM
Not only by date but by time as well

Question by:Jaziar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

Arunkumar earned 600 total points
ID: 8176116
Did you select the column property as date&Time ?  I guess that would do the trick for you !


Author Comment

ID: 8176309
I got it working thanks

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month10 days, 9 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question