SharePoint Online Json formatting with date based check

Question

I am trying to get something to work on SharePoint Online with JSON column formatting. What i have currently been able to achieve was, if a column is filled in ==> fill green if empty fill orange. I would like to convert this to a date-based check.

For example: When the column contains data = Fill it as green & show text in white

If todays date = or is less then the date in LaunchDate Column AND the field is empty ==> Fill it red

todays date equals or is more then 1 month before LaunchDate ==> Fill Yellow

1 month or less before launch date =:=> fill Orange.

I am struggeling with stringing this all together. Any ideas?

After applying solution suggested below i get as result(i emptied an expired field to illustrate:

Answer 1

Here are the rules as I understand them:

• Column has a value: Green with White text
• Column has no value and LaunchDate is in the past: Red
• Column has no value and LaunchDate is within 30 days: Orange
• Column has no value and LaunchDate is more than 30 days out: Yellow

Assuming those are correct, this format should work. Just apply it to each column (column settings > format this column > advanced mode) you'd like it applied to and be sure LaunchDate remains part of the view.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField.displayValue",
  "attributes": {
    "class": "=if(length(@currentField), 'ms-bgColor-green ms-fontColor-white', if([$LaunchDate] <= @now, 'ms-bgColor-red', if([$LaunchDate] <= addDays(@now,30), 'ms-bgColor-orange', 'ms-bgColor-yellow')))"
  }
}

I used the ms-bgColor-* classes since that was easier to map to your preferred colors. However, the sp-css-backgroundColor-* or sp-field-severity--* classes may be closer to what you're looking for.