OraFAQ Forum: Forms » Setting a date 18 years in the future

Home » Developer & Programmer » Forms » Setting a date 18 years in the future (oracle froms builder 10g)

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

Setting a date 18 years in the future [message #501140]

Sat, 26 March 2011 03:55

snookian
Messages: 17
Registered: December 2010

Junior Member

I am trying to set a item to system date + 18 years. I do not have any idea what type of formula or where to put such a thing. i tried putting- select add_months(sysdate,216) from dual; into the calculation-formula in property palette with no success. can anyone tell me how to do this please.

Report message to a moderator

Re: Setting a date 18 years in the future [message #501141 is a reply to message #501140]

Sat, 26 March 2011 04:22

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Depending on WHEN you want to do that, WHEN-NEW-FORM-INSTANCE or PRE-TEXT-ITEM triggers might be OK. SELECT is not necessary, simply

:block.date_item := add_months(sysdate, 216);

Report message to a moderator

Previous Topic:	Form Builder 10G Software
Next Topic:	Age condition trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:07:48 CDT 2024