enter image description here

I want to display only date and remove extra 22:00:00Z value. Dont know why it is appearing in View form as i am using only Date in this column type.


For SP 2010

You can edit it with SharePoint designer > then convert it to data view > edit date to look like

<xsl:value-of select="ddwrt:FormatDate(string(@StartDate), 1033, 3)"/>  

The syntax is

<xsl:value-of select="ddwrt:FormatDate(string(@StartDate), [LCID],[FORMAT FLAG])"/>

For SP 2013

Got List Settings > Click on your date column name to modify it > select date only > Check Display format Friendly.

enter image description here

  • Always go with changing it to Date Only from Date & Time even if it is SP 2010. – Unnie Jul 26 '16 at 9:56
  • 1
    At his quest. he said he has already set it as Date only and not worked – Mohamed El-Qassas MVP Jul 26 '16 at 10:01
  • earlier : <xsl:value-of select="@Start_x0020_date_x0020_of_x0020_" /> Now: <xsl:value-of select="ddwrt:FormatDate(@Start_x0020_date_x0020_of_x0020_, 1033, 3)" /> This is giving error,is syntax correct? – Akul Jul 26 '16 at 10:09
  • Are you sure the internal name end with _ and look like Start_x0020_date_x0020_of_x0020_ – Mohamed El-Qassas MVP Jul 26 '16 at 10:16
  • yes it ends with _ . Is there any workaround for this , using sharepoint designer2010 – Akul Jul 26 '16 at 10:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.