Forum Discussion
JSON Code for a date column is equal today's date or 30 days to today's date
Hello All, I have a SharePoint list which as several columns. Two of them are date columns. 1-Date revised 2-Next revision date I have a calculated Next revision date column which shows: A...
- Thanks rob. I think you almost got it.
It should be like this:
The Next Revision Date=Date Revised+365 days
Date Revised
If the Next Revision date is now()- 30 days : Amber
If the Next Revision date is greater than now() is: Red
Otherwise show it as Green.
What's the formula in your next revision date calculated column?
Next revision date=[Revised Date]+365
Naligurtan given that your calculated has the next revision date formula as Date revised +365 I don't quite see how your option A) will ever be met because it will never be more than 365 days ahead of the date revised column.
But I've included it in the following JSON which you add in advanced mode and which will handle the other 2 options.
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField <= addDays(@now,0), 'gold', if(@currentField > addDays([$Daterevised],365), 'red','green')", "color": "=if(@currentField <= addDays(@now,0), 'black', 'white')", "padding-left": "10px" } }Rob
Los Gallardos
Microsoft Power Automate Community Super User
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Thanks rob. I think you almost got it.
It should be like this:
The Next Revision Date=Date Revised+365 days
Date Revised
If the Next Revision date is now()- 30 days : Amber
If the Next Revision date is greater than now() is: Red
Otherwise show it as Green.- I found the solution. This works fine.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "[$NextRevisionDate.displayValue]",
"style": {
"background-color": "=if([$NextRevisionDate] > @now, '#FF0000', if([$NextRevisionDate]<(@now-2592000000), '#008000', '#ff8204'))",
"box-sizing": "border-box",
"padding": "0 2px",
"overflow": "hidden",
"text-overflow": "ellipsis"
},
"attributes": {
"class": "sp-css-backgroundColor-BgLightGray sp-field-fontSize13 sp-css-color-white"
}
}
