Hello.
Below LCS transform is having issue. Any help?
The requirement is start date less than or equal to today set to active and based on the term date today immediately set to inactive
For start date it showing Active. which looks good

End date(termDate) is 4/5/2024 but it is showing Active instead of inactive.

{
"name": "test LifecycleState",
"type": "static",
"attributes": {
"requiresPeriodicRefresh": "true",
"activestate": {
"attributes": {
"firstDate": {
"type": "firstValid",
"attributes": {
"values": [
{
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "Start Date",
"sourceName": "test"
}
},
"inputFormat": "MM/dd/yyyy",
"outputFormat": "ISO8601"
},
"type": "dateFormat"
},
"2000-01-01T00:00:00Z"
]
}
},
"secondDate": "now",
"operator": "LTE",
"positiveCondition": "yes",
"negativeCondition": "no"
},
"type": "dateCompare"
},
"termination": {
"attributes": {
"firstDate": "now",
"secondDate": {
"type": "firstValid",
"attributes": {
"values": [
{
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "TermDate",
"sourceName": "test"
}
},
"inputFormat": "MM/dd/yyyy",
"outputFormat": "ISO8601"
},
"type": "dateFormat"
},
"now"
]
}
},
"operator": "LTE",
"positiveCondition": "yes",
"negativeCondition": "no"
},
"type": "dateCompare"
},
"value": "#if($activestate == 'yes')Active#elseif($termination == 'yes')inacive#end"
},
"internal": false
}