I am using Crystal 11
I am trying to get the difference between dates based on the approver of an invoice.
Approver 1 approves invoice on 12/3/14
Approver 2 approves invoice on 12/6/14
Approver 3 approves invoice on 12/15/14
I need to get the number of days between approvals.
My fields are ApprovalSeq (approver number) DateApproved
I need to see it like this
Approver 1 12/3/14
Approver 2 12/6/14 3 days
Approver 3 12/15/14 9 days
Any help would be appreciated.
Gina
I am trying to get the difference between dates based on the approver of an invoice.
Approver 1 approves invoice on 12/3/14
Approver 2 approves invoice on 12/6/14
Approver 3 approves invoice on 12/15/14
I need to get the number of days between approvals.
My fields are ApprovalSeq (approver number) DateApproved
I need to see it like this
Approver 1 12/3/14
Approver 2 12/6/14 3 days
Approver 3 12/15/14 9 days
Any help would be appreciated.
Gina