SQL Function to Return Last Workflow Final Approval Date

The below SQL function returns the last Microsoft Dynamics GP workflow final approval date and time; it is always returned, not just when final approved is the current status.

This function was created to be used in a check of approved documents to see when they had last been approved; it was used in conjunction with the SQL function which returns the current workflow status.

IF object_id(

Continue Reading azurecurve’s Article on their blog

SQL Function to Return Last Workflow Final Approval Date

The below SQL function returns the last Microsoft Dynamics GP workflow final approval date and time; it is always returned, not just when final approved is the current status. This function was cr‎…

Blog Syndicated with azurecurve’s Permission