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":"0 2px","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_]"}