Managing DATE in FORMS
Date: 1997/02/26
Message-ID: <33147016.B8B_at_kjws.com>#1/1
I'm in trouble for the following problem:
I was told from hot line service the problem is the following: a database date value contains (of course) not only the date but also the hour ... so when I try to inquery just by date, I get nothing.
First question: is it true?
Second problem: how to resolve it?
2- in the form, manage the date field in the following manner:
IF :nodb_block.ins_date IS NOT NULL THEN
Set_Block_Property('block0',DEFAULT_WHERE,'To_Char(ins_date)='''||To_Char(:nodb_block.ins_date)||'''');
ELSE
Set_Block_Property('block0',DEFAULT_WHERE,NULL);
END IF;
please, answer me directly too
thank you very much in advance Received on Wed Feb 26 1997 - 00:00:00 CET