Avatar

Correct answer by
Community Advisor

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

 

 

View solution in original post