Home » Developer & Programmer » Reports & Discoverer » Difference of dates in days (Oracle 12c forms and reports)
Difference of dates in days [message #675851] Wed, 24 April 2019 00:02 Go to next message
lacchhii
Messages: 142
Registered: May 2009
Location: bangalore
Senior Member

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

Re: Difference of dates in days [message #675852 is a reply to message #675851] Wed, 24 April 2019 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 13759
Registered: September 2008
Location: Rainy Manchester
Senior Member
Number of days isn't a date, it's a number.
Re: Difference of dates in days [message #675853 is a reply to message #675852] Wed, 24 April 2019 04:34 Go to previous message
lacchhii
Messages: 142
Registered: May 2009
Location: bangalore
Senior Member

thank you sir, now i realised it. Thanks a lot
Previous Topic: Reports Generation I/O Error
Next Topic: Water Mark on Reports(Urgent!)
Goto Forum:
  


Current Time: Sat Dec 14 18:33:30 CST 2019