This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Hello,
We would need to change the formatting to show the exact time and date of creation.
This could be solved using JSON formatting, but I don't know exactly what to write.
I tried using ChatGPT, but I didn't get a working solution (the code below shows this)
Please help
Thank you
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"style": {
"box-sizing": "border-box",
"padding": "0 2px",
"overflow": "hidden",
"text-overflow": "ellipsis"
},
"children": [
{
"elmType": "span",
"style": {
"overflow": "hidden",
"text-overflow": "ellipsis",
"padding": "0 3px"
},
"txtContent": "=formatDateTime([$Created], \"dd.MM.yyyy HH:mm:ss\")",
"attributes": {
"class": "sp-field-fontSizeSmall sp-css-color-LightGrayFont"
}
}
]
}
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Hi @Michal Rama
Thank you for posting your question in the Microsoft Q&A forum.
To assist you better, I will need more information.
Do you want to show the full MM/DD/YYYY and the time like the picture below?
If yes, you just need to turn on "Include Time".
Or do you want to use JSON to format the column?
Please provide more information so I can assist you better.
Hello,
This isn't a time column, which I have added in a separate table.
This column does exactly what I need and is predefined to contain the current time. The problem with it is that it can be edited in the form for adding a new item, which I don't want in the second table.
A predefined column with the creation date is perfect for this, which doesn't have to be in the form for adding a new item and will still contain this information.
However, it cannot be edited like the standard "Date and Time" column, even though it looks that way at first glance.
The only solution is probably a correct JSON definition. Or is there another way to solve this?
Thanks
Hi @Michal Rama
Thanks for your clarification.
You're in the right place.
You just need to choose "Standard" and delete the JSON code below.
The created column will show the time.
Hello,
Oh. I never thought of trying that. "Standard" and "Descriptive" are pretty unintuitive, with nothing written about them.
Anyway, that's exactly what I wanted. It's now displaying correctly.
Thank you very much and have a nice day
Michal
Hi @Michal Rama
Glad that I was able to help you.
