Calculated Column and Date Time Formats

After much searching I found some formats that work, but have not found a good reference document.

To modify the format of a date or time, convert the column to text and apply these formats as needed.

 

Month m, mm
Day d, dd
Year yy, yyyy
Hour h, hh
Minute m, mm
Second s, ss
AM/PM AM/PM

Of course you need to go into SharePoint Designer and do a nowrap=”true” on the <td> if the date renders on 2 lines.

 

Leave a Reply

Your email address will not be published. Required fields are marked *