{
"name": "New Contract Expiration Check Transform1",
"type": "conditional",
"attributes": {
"firstDateabc": {
"attributes": {
"values": [
{
"attributes": {
"input": {
"attributes": {
"sourceName": "New_Source_CNexpTest",
"attributeName": "CONTRACT_END_DATE"
},
"type": "accountAttribute"
},
"inputFormat": "MM/dd/yyyy",
"outputFormat": "ISO8601"
},
"type": "dateFormat"
}
]
},
"type": "firstValid"
},
"secondDate": {
"attributes": {
"input": "",
"expression": "now+14d",
"roundUp": false
},
"type": "dateMath"
},
"expression": "$secondDate eq $firstDate",
"positiveCondition": "true",
"negativeCondition": "false"
},
"internal": false
}
This transform should return true if the input for the “CONTRACT_END_DATE” is a date that is exactly 14 days ahead from the current date. But it is returning false even when condition is satisfied. My input format is ‘MM/dd/yyyy’ (6/30/2023). Output is flase for all cases