Thursday, July 10, 2008

SP2007: Date Only in View

Sometimes it might be useful to have a simplified View for a Document Library that only shows the Modified Date, instead of the Date and Time.

You can get this effect by creating a new Column, and setting it to the Calculated type. Calculated columns allow you to preform calculations similar to what you might do in Excel.

The formula you need to display the date only is:

=TEXT([Modified],"MM/DD/YYYY")

Changing the last part allows you to change how that date is displayed. For example, MM is a 2 digit month, while MMM is a three character month abreviation (Jan, Feb, Mar) and MMMM is the full month name.