OraFAQ Forum: Reports & Discoverer » Derived field using Dates???

Home » Developer & Programmer » Reports & Discoverer » Derived field using Dates???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Derived field using Dates??? [message #141516]

Mon, 10 October 2005 12:34

abardel
Messages: 3
Registered: October 2005

Junior Member

Hello,
I hope I am posting this question in the correct area. What I need is a derived field to do the following:

If Termination Date is < 06/01/05, then make the term date null, otherwise display the term date.

I have tried several things but they are not working, any suggestions would be greatly appreciated.

Thanks

Report message to a moderator

Re: Derived field using Dates??? [message #141595 is a reply to message #141516]

Tue, 11 October 2005 02:20

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Does a format trigger on the term date work for you?

MHE

Report message to a moderator

Re: Derived field using Dates??? [message #141648 is a reply to message #141595]

Tue, 11 October 2005 07:53

abardel
Messages: 3
Registered: October 2005

Junior Member

I'm not sure I understand what you are asking... I have also tried '01-JUN-05' with no luck. (hope that helps)

Report message to a moderator

Re: Derived field using Dates??? [message #141660 is a reply to message #141648]

Tue, 11 October 2005 09:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You do compare dates with dates, right?

But, instead of making it NULL, you can use a format trigger: make it return FALSE if you don't want to show the field etc.

Are we talking Reports here?

MHE

Report message to a moderator