1

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.

Improve this question
8
  • What error do you get when you are using Created?
    – Keerthi
    Commented Jun 12, 2015 at 15:00
  • "Sorry something went wrong" "The formula contains reference(s) to field(s)."
    – Tom
    Commented Jun 12, 2015 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
    Commented Jun 12, 2015 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
    Commented Jun 12, 2015 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
    Commented Jun 12, 2015 at 15:22

1 Answer 1

Reset to default
1

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

Improve this answer
0

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.