Home » Developer & Programmer » Reports & Discoverer » null date
null date [message #672143] Thu, 04 October 2018 05:11 Go to previous message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
i have a table which contains following columns.
Table Name:  Fees
Stuid   Number(5),
Chl_no  number(7),
Fmonth  varchar2(30),
Fdate   date,
fyear   number(4),
if fmonth is "october" and fdate is null then it is showing nothing in report. but when i put date in fdate column . the reports shows data. i want to shows the all report wether fdate is null or having a date.

AND isnull(fdate,date) between :fd AND :td
or 
AND fdate between isnull(:fd,date) AND inull(:td,date) 

[Updated on: Thu, 04 October 2018 05:48]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Matrix Report
Next Topic: How to add watermark in pdf
Goto Forum:
  


Current Time: Fri Apr 10 01:01:57 CDT 2020