Invoice Approval based on date stored in descriptive flexfield

Summary

DFF attributes of number and date type in invoice approvals

Content

Hi,

We have the below requirement.

We store completion date of a task in the invoice distribution flexfield ( it comes from a requisition ).

If the invoice date is later than completion date plus 30, then it need to go for a special approval.

How can this be achieved.

I could not find any date or number related DFF fields among approval attributes.

Please share your experience on how you handled similar date related requirements in approvals.

Thank you

 

Version

R13 19D