JSON Validate date on Sharepoint

Question

I'm new on JSON script.

I just write on sharepoint 365 online

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "=if(@now>=[$StartDate],if(@now<=[$EndDate],'active','non active'),'non active')"
}

My problem the result always non active when it saved. I need status will be active if date range on current month and will be change automatically to Non Active if out of current month

I hope my pic can tell about my problem

Thanks everyone

JSON Validate Date

Answer 1

My test result for your reference: