Forum Discussion

Smitster's avatar
Smitster
Copper Contributor
Aug 20, 2025

SharePoint List 'Calendar View' - hide if time 00:00

Hi, hope I am in the right spot for this.

I have a data SharePoint List and from that a calendar view.  Some items are classed as all day events, and others are time specific.
For all day events I see 00:00 as the start time, and I would prefer to hide this in some way.

Can i hide the 00:00 somehow in advanced column formatting?

Can't use any calculated value as Calendar View cannot use them.

I would rather not Power Automate it if possible.


Thanks for looking.

Lists
microsoft lists
SharePoint Online

2 Replies

  • PankajBadoni's avatar
    PankajBadoni
    Iron Contributor
    Aug 21, 2025

    Hi Smitster​,

    Unfortunately, it's not possible to hide the time from the SharePoint Calendar view.

    Standard column formatting using JSON does not apply here. Calendar views use a different schema—calendar-formatting.schema.json—which currently does not support removing or conditionally hiding the time portion.
    You can refer to Microsoft’s documentation for more details:

    https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/view-calendar-formatting

    Alternative Suggestion:
    If it aligns with your project requirements, consider using the Events web part instead of the Calendar view. It offers a cleaner display and more flexibility in how event details are presented.

     

    ----------------------------------------------------------------------------------------------------------

    If this response resolves your query, please mark it as the accepted answer.

  • Smitster's avatar
    Smitster
    Copper Contributor
    Aug 20, 2025

    I must be missing something as none of these json column formats are working...

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "span",
      "txtContent": "=if(indexOf(toString([@currentField]), '00:00') != -1, [@currentField], toLocaleDateString([@currentField]))"
    }


    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "span",
      "txtContent": "=if(getHours([@currentField]) == 0 && getMinutes([@currentField]) == 0, [@currentField], toLocaleDateString([@currentField]))"
    }

     

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "span",
      "txtContent": "=if(formatDateTime([@currentField], 'HH:mm') == '00:00', [@currentField], toLocaleDateString([@currentField]))"
    }

     

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
      "elmType": "span",
      "txtContent": "=if(indexOf(toISOString([@currentField]), 'T00:00:00') != -1, [@currentField], toLocaleDateString([@currentField]))"
    }

Resources