JSON Format sharepoint list format to calculate days left before expiration date or due date

Question

hello,

i have a column in sharepoint list called "Expiration Date" i would like to get the number of days left before the expiration date. im using the JSON format below.
the JSON format is working but i would to get a round number in return without decimal points.

{
"$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
"elmType": "div",
"txtContent": {
"operator": "/",
"operands": [
{
"operator": "-",
"operands": [
{
"operator": "Number()",
"operands": [
"@now "
]
},
{
"operator": "Number()",
"operands": [
"[$ExpirationDate]"
]
}
]
},
86400000
]
}
}

Answer 1

You can use floor() operation to return the largest integer less than or equal to the calculated value.

{  
    "elmType": "div",  
    "txtContent": {  
        "operator": "floor",  
        "operands": [  
            {  
                "operator": "/",  
                "operands": [  
                    {  
                        "operator": "-",  
                        "operands": [  
                            "=Number('@now')",  
                            "=Number('[$ExpirationDate]')"  
                        ]  
                    },  
                    86400000  
                ]  
            }  
        ]  
    }  
}  

Here is the test result:

Reference: Use column formatting to customize SharePoint.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **