<div>
&gt;&gt;&gt; Does not work.<br />
<br />
why not? &nbsp;what happens? error? no results? wrong results? keyboard catches fire?
</div>


>>> Does not work.

why not?  what happens? error? no results? wrong results? keyboard catches fire?

<div>
I tried to_date,<br />
<br />
cursor stays on the field. No error message displayed
</div>


I tried to_date,

cursor stays on the field. No error message displayed

<div>
<div class="content wysiwyg-content">
filtration_start &nbsp; &nbsp; date ( format - MM/DD/RRRR HH24:MI)<br />
<br />
04/05/2012 14:24<br />
<br />
filtration_end &nbsp; &nbsp; date ( format - MM/DD/RRRR HH24:MI)<br />
<br />
04/05/2012 15:30 changed this to 04/05/2012 13:10<br />
<br />
I need to make sure end_filtration is &gt;&nbsp;start_filtration<br />
<br />
if :filtration_end &lt;&nbsp;:filtration_start then<br />
&nbsp; msgbox.show('Error', 'Filtration End date has to be greater than Filtration Start date.', 'OK');<br />
raise form_trigger_failure;<br />
End if;<br />
<br />
Does not work. Need help.
</div>
</div>


filtration_start     date ( format - MM/DD/RRRR HH24:MI)

04/05/2012 14:24

filtration_end     date ( format - MM/DD/RRRR HH24:MI)

04/05/2012 15:30 changed this to 04/05/2012 13:10

I need to make sure end_filtration is > start_filtration

if :filtration_end < :filtration_start then
  msgbox.show('Error', 'Filtration End date has to be greater than Filtration Start date.', 'OK');
raise form_trigger_failure;
End if;

Does not work. Need help.

oracle date question

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.