wasim_sono
Registered User.
- Local time
- Today, 04:18
- Joined
- May 29, 2008
- Messages
- 33
Dear All
I have a program about "complaints". It has a table-field "comp_status" which holds the data either "Pending" or " Resolved" and comp_recvd_date and comp_resolved_date. I have also a report for the program.
In this report I used a calculated field "Aging" which calculate the aging of the complain by difference of today and complain date.
I need to calculate aging of complain by following"
Is it possible to use this code on opening of the report or any other procedure is required?
I have a program about "complaints". It has a table-field "comp_status" which holds the data either "Pending" or " Resolved" and comp_recvd_date and comp_resolved_date. I have also a report for the program.
In this report I used a calculated field "Aging" which calculate the aging of the complain by difference of today and complain date.
I need to calculate aging of complain by following"
Code:
if comp_status = " pending then
Aging = now() - comp_recvd_date
elseif comp_status = "Resolved" then
Aging = comp_resolved_date - comp_recvd_date
Is it possible to use this code on opening of the report or any other procedure is required?