Difference of dates in days [message #675851] |
Wed, 24 April 2019 00:02 |
|
Hi friends,
i want to get the difference between two dates as number of days.
I want to check the number of days taken for processing. The two dates are dispatch date and Received date.
I have created a CF for Received date and there is a attribute in a table for dispatch date.
I am able to get the value for received date and dispatch date.
All i want is the difference between these two dates as number of days taken for processing
My coding for this is as below
function CF_9Formula return Date is
TOT_DAYS DATE;
begin
TOT_DAYS:=(:DESPATCH_DATE-:CF_7);
RETURN TOT_DAYS;
end;
i get an error message "expression is of wrong type".
Could anyone please help me correct this.
Thanks in advance
|
|
|
|
|