I'm trying to set up conditional formatting on a List for Due Dates (SharePoint online).
I can't seem to get the correct code for Due Date is between today and 5 days from now. If I use an arbitrary date for one of the dates it works, but as soon as I add @now + 432000000 (5 days in milliseconds) it doesn't work.
If I use on or before @now + 432000000 it works so the function to calculate the date isn't the problem.
Code below:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"style": {
"box-sizing": "border-box",
"padding": "02px",
"overflow": "hidden",
"text-overflow": "ellipsis"
},
"attributes": {
"class": {
"operator": ":",
"operands": [
{
"operator": "&&",
"operands": [
{
"operator": "!=",
"operands": [
"[$FileStatus]",
"Decided"
]
},
{
"operator": "&&",
"operands": [
{
"operator": "=",
"operands": [
{
"operator": "Date()",
"operands": [
{
"operator": "toDateString()",
"operands": [
{
"operator": "Date()",
"operands": [
"[$Decision_x0020_Due]"
]
}
]
}
]
},
{
"operator": "Date()",
"operands": [
{
"operator": "toDateString()",
"operands": [
{
"operator": "Date()",
"operands": [
"@now"
]
}
]
}
]
}
]
},
{
"operator": "=",
"operands": [
{
"operator": "Date()",
"operands": [
{
"operator": "toDateString()",
"operands": [
{
"operator": "Date()",
"operands": [
"[$Decision_x0020_Due]"
]
}
]
}
]
},
{
"operator": "Date()",
"operands": [
{
"operator": "toDateString()",
"operands": [
{
"operator": "Date()",
"operands": [
"@now + 432000000"
]
}
]
}
]
}
]
}
]
}
]
},
"sp-css-backgroundColor-BgGold sp-css-borderColor-GoldFont sp-field-fontSizeSmall sp-css-color-GoldFont",
""
]
}
},
"txtContent": "[$File_x0023_]"
}