You could try the conditional transform, which compares two values using the eq
operator. Your transform might look like this:
{
"attributes": {
"firstDate": {
"attributes": {
"values": [
{
"attributes": {
"input": {
"attributes": {
"sourceName": "Delimited File",
"attributeName": "HIRE_DATE"
},
"type": "accountAttribute"
},
"inputFormat": "ddMMyyyy",
"outputFormat": "ISO8601"
},
"type": "dateFormat"
},
{
"attributes": {
"input": "31121999",
"inputFormat": "ddMMyyyy",
"outputFormat": "ISO8601"
},
"type": "dateFormat"
}
]
},
"type": "firstValid"
},
"secondDate": {
"type": "dateMath",
"attributes": {
"expression": "now",
"roundUp": true
}
},
"expression": "$firstDate eq $secondDate",
"positiveCondition": "Active",
"negativeCondition": "Inactive"
},
"type": "conditional",
"id": "PRE_HIRED DATE COMPARISON"
}