B i t s O f S h a r e P o i n t C o n s u l t i n g L L C > B l o g P o i n t > Posts > Calculated Column - Formula - Fix Sort by Date
Calculated Column - Formula - Fix Sort by Date
I had an issue where I wanted to sort by date, but since by default SharePoint formats a date as 5/25/2008 and 12/2/2008, sorting caused the Dec. date to sort first then the May Date.
 
My solution was to create a calculated column that formatted a date in way that is could be easily sorted.  mm-dd-yy.
 
  1. Create a new Calculated column
  2. In the Formula box, enter something like this: =TEXT([existing date column],"mm-dd-yy") You can use any date format string you like instead of "mm-dd-yy"
  3. Make the data type "Date and Time"
  4. Make the date and time format "Date Only"

This worked great for me.  Sorting worked as it should and grouping worked very well too.

Comments

There are no comments yet for this post.
Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Addition: 2 + 1 = *


Please complete this equation.

Email


This is optional.
Attachments

 T o p i c P o i n t

 E x a m p l e P o i n t