OraFAQ Forum: Forms » how to insert an invalid date

Home » Developer & Programmer » Forms » how to insert an invalid date (forms 6i)

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

how to insert an invalid date [message #362519]

Tue, 02 December 2008 10:22

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?

Report message to a moderator

Re: how to insert an invalid date [message #362529 is a reply to message #362519]

Tue, 02 December 2008 12:19

Littlefoot
Messages: 21823
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.

Report message to a moderator