ENV : SharePoint Server 2013

Language : French

We've migrated a list from a 2010 site collection (in our 2013 environment) to a 2013 site collection using the Export-SPWeb function.

In the 2010 site collection, we're using the "Group By" statement on a calculated column. Formula is as follows :

enter image description here

and the view shows the values correctly :

enter image description here

But after migrating the list in the 2013 site, "group by" values aren't shown anymore (Formula is the same):

enter image description here

Any idea ?


  • Try creating a new test column using the same formula as before and group on that. Just to test if it is some problem with the migration.
    – unibod50
    Jun 11, 2018 at 9:07
  • Same issue with the test column.
    – KhalilG
    Jun 11, 2018 at 9:10
  • Yes - this seems to be a SP 2013 issue with dates used in calculated date columns. Works okay on the original date column. I will post a possible work around as an answer.
    – unibod50
    Jun 11, 2018 at 9:30

1 Answer 1


This does appear to be an issue with SP 2013 when using a calculated column on a date field returned as a date. The usual reason for doing this is when you have an original data column with a name that you don't want to have displayed. So you create a calculated column with the new name.

=[Original Date Column Name]

The only workaround I have found is to return the date as a single line of text and use the following formula to create the date. Because strings are sorted alphanumerically you will need to return YYYY_MM_DD and this will need some zero padding for months and days <10.

=YEAR(Date)&"_"& IF(LEN(MONTH(Date))=1,"0","")&MONTH(DATE)&"_"& IF(LEN(DAY(Date))=1,"0","")&DAY(Date)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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