Customizing DateTime format on a List view Web part

SharePoint does not allow you to format the output in a list view web part. Here is a little trick on how to fix that.

  • Create a new calculated column for your list (single line of text)
  • Use the following formula to calculate its value


=TEXT([Column Name],”dd mmm yy”) – To Display the Date Only

=TEXT([Column Name],”hh mm”) – To Display the Time Only