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
}