OraFAQ Forum: Forms » Adding 5 mins to a form field, in a library

Home » Developer & Programmer » Forms » Adding 5 mins to a form field, in a library

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

Adding 5 mins to a form field, in a library [message #588270]

Mon, 24 June 2013 06:11

ahazin
Messages: 39
Registered: August 2010

Member

Hi guys,

Im having a bit of trouble and would really appreciate some help. I have a date field in my form (date.start_time) in which I want to reference in a library and add 5 mins to the time (since its in the lib I am coding this I need to use name_in ). My current code is:

copy(name_in('date.start_datetime')+5/24/60 , 'DATE.END_DATETIME')

However, this seems to be erroring, could anyone help me out please?

Any help greatly appreciated.

Report message to a moderator

Re: Adding 5 mins to a form field, in a library [message #588271 is a reply to message #588270]

Mon, 24 June 2013 06:16

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

What error are you getting?

Report message to a moderator

Re: Adding 5 mins to a form field, in a library [message #588288 is a reply to message #588270]

Mon, 24 June 2013 10:27

azamkhan
Messages: 557
Registered: August 2005

Senior Member

I think the error is occurring because you are trying to add date improperly.

Don't add the date directly. Instead try to add the date using TO_DATE() function.

I hope then you will achieve your desired result

[Updated on: Mon, 24 June 2013 10:28]

Report message to a moderator

Previous Topic:	Error-7033 in Total Folder Form fields
Next Topic:	Text box value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:35:46 CDT 2024