Forum Discussion

kobi1991's avatar
kobi1991
Copper Contributor
Jan 11, 2023
Solved

Countdown to due date in SharePoint 365 list

Hello!   I'm using a SharePoint 365 list as an action tracker. My list contains the due date. I would like to add a column that contains a count of days remaining to the due date.    I tried the ...
Lists
SharePoint Online
Sites
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Jan 11, 2023

kobi1991 

You could apply JSON Formatting:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=floor((Number(@currentField)-Number(Date((getMonth(@now)+1)+'.'+getDate(@now)+'.'+getYear(@now))))/(60*60*24*1000))+' day(s) remaining'"
}

 

 


Best Regards,

Sven

  • kobi1991's avatar
    kobi1991
    Copper Contributor
    Jan 11, 2023

    SvenSieverding 

     

    Thank you, Sven! Apologies but I'm completely new at this - could you please explain where in the code I should put my 'due date' column? 

     

    Karolina

    • SvenSieverding's avatar
      SvenSieverding
      Bronze Contributor
      Jan 11, 2023

      Hi kobi1991 ,

       

      sure. This is SharePoint Json list formatting code that formats a column.

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

      Got to you SharePoint View, select the header of your "Due Date" column and select "Column Settings->Format this Column"

      Copy the Json Code here


      You don't have to change the formula, as "@currentField" references to the selected Column.

      Best Regards,
      Sven

      • faric1311's avatar
        faric1311
        Copper Contributor
        Jun 22, 2023

        Hi SvenSieverding,

         

        I have a question about your json code, i have tried to apply the code into my list but all the dates that have past due displays for example "-29 days", is there any code that could make all the dates that have past due displays "0 days"

         

        Thanks

        Best Regards, 

        Faric 

Resources