Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date calculation

10029Sep 4 2002

Hi Everyone!

I have a form which as a button that does some date calculation. I want to compare to dates together. I am using sysdate and hire_date.

Here's my piece of code:

begin
tmp := hire_date;
select to_char(add_months(sysdate,-1),'mm/')||'1/'||to_char(sysdate,'rr') into tmpbeg from dual;

if tmp >= tmpbeg then
...
end if;

I receive an error on my select statement (I tried the select statement in SQLPlus and it work fine). The error is: PDE-XDA001 Date operation failed (Oracle Error).

DB: 7.3.4 Forms: 6.0.8.12.1

Thanks in advance.

~Vannette

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2002

Added on Sep 4 2002

#forms, #moved-from-devops

2 comments

322 views