- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi @David__Garcia ,
1) Try using below syntax to fetch the value of 'changeDate':
Substring(data, Charindex(data, 'changeDate='), 19)
Once you save 'changeDate' value, then you can use another enrichment activity to use your code.
2) Or use complete code in one syntax:
Iif(Abs(((Substring(data, Charindex(data, 'changeDate='), 19)) - GetDate()) / 36e5) >= 72, 'Expired','Pending')
Thanks,
Jyoti