Forum Discussion
JSON Sharepoint Date Validation
Can you please add more details about your requirement & conditions to check?
Do you want to show the column value as "Active" when current (today's) date is in between Start date and End Date? Or if both the Start date and End date are in current month?
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Can you please add more details about your requirement & conditions to check?
Do you want to show the column value as "Active" when current (today's) date is in between Start date and End Date? Or if both the Start date and End date are in current month?
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap sorry for my question is have a little missing.
I mean is "Active" when current (today's) date is in between Start date and End Date.
Thanks for your help
Try using below JSON code. It should work for you:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(@now >= [$StartDate] && @now <= [$EndDate], 'Active', 'Not Active')" }Microsoft documentation: Use column formatting to customize SharePoint
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
What is the internal name of Start date and End date columns?
In JSON formatting, you need to use internal name of your columns to refer their value in JSON code. Check below documentation to find out the internal names of start date and end date. and use those in place of [$StartDate] and [$EndDate].
Follow this article to get the internal name your SharePoint column: Find the internal name of SharePoint column
Here is the output of the same code in my SharePoint list:
Microsoft documentation: [$FieldName]
