I found this nice calculated column, Days since list item was created

On the demo tenant it works awesome. So i tried it at the production version. Here is the default language Dutch but everything is now English.

When i use this code: =DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy"))

The output is: #Value! When i check the column, all the words are in Dutch. When i changed it back to English, i automatically changed to Dutch.

Is there a solution for this? I tried to write the code in Dutch but that doesn't work either.

  • 1
    Try ; instead of ,. In some language packages , is reserved for other usage. However, at least with SharePoint's PnP (using SharePoint Online) the calculated column usage with custom language packs is reported as a bug in here github.com/SharePoint/PnP-Sites-Core/issues/1236. – moe Jul 30 '18 at 11:21

Found it, simple mistake :)

=DATEVALUE(TEXT(NOW(),"dd/mm/yyyy")) - DATEVALUE(TEXT([Created],"dd/mm/yyyy"))

I changed dd/mm and now it works.

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.