I am trying to convert the "Created" column field, or at least create a computed field, in SharePoint 2013 Online to display MM/DD/YYYY HH:MM:SS. Is this possible in the UI or is it a limitation of Sharepoint?

I have tried a computed value in a text field using : =TEXT(Created, "MM/DD/YYYY HH:MM:SS") but all I get is an error when I click OK. I figured it was because created was a value set after you save a form. I also tried "NOW" but that didn't write out to seconds, only to minutes.

  • What error do you get when you are using Created? – Keerthi Jun 12 '15 at 15:00
  • "Sorry something went wrong" "The formula contains reference(s) to field(s)." – Tom Jun 12 '15 at 15:02
  • I created a column using this formula - =TEXT(Created, "MM/DD/YYYY HH:MM:SS") and it didn't give me any error – Keerthi Jun 12 '15 at 15:03
  • 1
    @Tom , localization do you use? For some reason the separator is not the same depending on locale. So try separating the Created and date format with a semi colon(;) instead of a comma (,) – Anders Aune Jun 12 '15 at 15:11
  • @AndresAune, I tried the semi colon and got a different error "The formula contains a syntax error or is not supported." – Tom Jun 12 '15 at 15:22

Figured it out, the issue was I was not using a computed field when I first created it

| improve this answer | |

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.