Forum Discussion
Solved
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?