Jan 26 2023 06:14 PM
Hello,
I have two date/time columns. They must continue to display as below:
Due to OPO internal name is DuetoOPO
Requestor Due date internal name is DueDate
We would like to use inlineEditField so users can just click to update due date times.
If I apply this JSON:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"inlineEditField": "[$DuetoOPO]",
"txtContent": "[$DuetoOPO]"
}
SharePoint displays the seconds after the due date. How can I format so it will only show the date and time with HH:mm after applying the inlineEditField JSON??
Jan 27 2023 10:08 AM
SolutionTry the following, which works in my testing. Different countries may have different results.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"inlineEditField": "@currentField",
"txtContent": "@currentField"
}
If that does not work for you, we can manually build a formatted date/time string.
If my answer helps solve or resolve your issue, please consider clicking Mark as Best Response & Like. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it a Like.
Jan 27 2023 01:56 PM
Jan 27 2023 10:08 AM
SolutionTry the following, which works in my testing. Different countries may have different results.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"inlineEditField": "@currentField",
"txtContent": "@currentField"
}
If that does not work for you, we can manually build a formatted date/time string.
If my answer helps solve or resolve your issue, please consider clicking Mark as Best Response & Like. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it a Like.