Wednesday, 12 February 2014

Here you can see how I change the Date format of SharePoint list column.

  • First add a new column  of Date and Time type(I named ExpiryDate) as follows:

  • You can leave calculated value and Press OK.
  • Then add another column so that new column can referenced by new one.I created(Expdate) column of calculated type as follows:
  • Click on existing column from the DropDown and type the Formula:
=Text([ExpiryDate],"YYYY/DD/MM") or
=Text([ExpiryDate],"YYYY-DD-MM") and Click on OK.

See Format of ExpiryDate and ExpDate Column.