Home » Developer & Programmer » Forms » how to insert an invalid date (forms 6i)
how to insert an invalid date [message #362519] Tue, 02 December 2008 10:22 Go to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Hello to all,

I have a form that has a calendar where users select a date for the field. My question is there a way a user can put in something else if they do not know the exact date, for example "in two weeks" instead of 02-Dec-2008. This current field is a date field, if I change this to a string will it effect the calendar and any other procedures that may be connected to it?
Re: how to insert an invalid date [message #362529 is a reply to message #362519] Tue, 02 December 2008 12:19 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"in two weeks" is not a date and can not be stored into a DATE datatype column. You could, however, create an additional column (call it "notice", for example), make it VARCHAR2(200) and let users enter whatever they want. Later, they'll be able to set the exact date and remove a notice.
Re: how to insert an invalid date [message #362660 is a reply to message #362529] Wed, 03 December 2008 11:00 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

thanks. good idea. however what if the calendar is in Portal?
Re: how to insert an invalid date [message #362690 is a reply to message #362660] Wed, 03 December 2008 14:52 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wouldn't know. My calendar is hanging on the wall ./fa/1580/0/


Just kidding; I really wouldn't know what difference would a Portal calendar do.
Previous Topic: OLE2 help
Next Topic: Progress Bar
Goto Forum:
  


Current Time: Sat Dec 03 04:13:20 CST 2016

Total time taken to generate the page: 0.09376 seconds