In a view of a document library I have the field "Modified" and this is showing only dates but no time. I would like to display the time aswell.
From my understanding it is ill advised to alter this field OOTB, but rather to create a calculated field and format it the way I want.
I have checked the column properties for this Modified-field, and it is set to "Date and time", which is why I find it curious that it only displays the date. In any case I have created another (calculated) field which I am attempting to format the way I want, but with not luck.
Under the Formula section of this new calculated field I am attempting to format "Modified" like this:
=TEXT([Modified],"dd.MM.yyyy hh:mm")
I want the result to appear like this 14.10.2014 15:59. However, when trying to save the above formula I get the "Sorry, something went wrong" page and the mention that the syntax is probably wrong. I am unable to see any obvious errors with the syntax and have tried a multitude of approaches - like removing the "", removing [] from modified and so forth.
I need the field to display time aswell and I am not sure if this is the best approach either. Anyone got any tips to how I could do this? Perhaps the calculated field approach isn't the best either?
Modified
column on your list fromFriendly
Display Format toStandard
?