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 previous message
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




i get an error message "expression is of wrong type".

Could anyone please help me correct this.

Thanks in advance

Read Message
Read Message
Read Message
Previous Topic: Reports Generation I/O Error
Next Topic: Water Mark on Reports(Urgent!)
Goto Forum:

Current Time: Mon Jan 27 11:07:45 CST 2020