OraFAQ Forum: Forms » date format

Home » Developer & Programmer » Forms » date format

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

date format [message #474145]

Fri, 03 September 2010 02:58

narang79
Messages: 137
Registered: June 2010

Senior Member

sir in form builder
i have a text field emp_date datatype is date
i assigned format dd/mm/rrrr

but when i entered data 03-09-0010 then it is accepted but
my requirement is accepted only format date i.e 03-09-2010

Report message to a moderator

Re: date format [message #474147 is a reply to message #474145]

Fri, 03 September 2010 03:45

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

Senior Member

Not sure what you mean by format date - 03-09-0010 is perfectly valid.
You do realise that rrrr is the same as yyyy. Only rr works differently.

Report message to a moderator

Re: date format [message #474148 is a reply to message #474145]

Fri, 03 September 2010 04:12

narang79
Messages: 137
Registered: June 2010

Senior Member

sir i want user can not enter 03-09-0010 date saved in 03-09-2010
so what can i do

Report message to a moderator

Re: date format [message #474149 is a reply to message #474148]

Fri, 03 September 2010 04:14

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

Senior Member

Try changing the format to dd-mm-rr

Report message to a moderator

Re: date format [message #474158 is a reply to message #474149]

Fri, 03 September 2010 04:51

narang79
Messages: 137
Registered: June 2010

Senior Member

sir but actually i want full year shown on screen

like 03-09-2010 instead of 03-09-10

Report message to a moderator

Re: date format [message #474176 is a reply to message #474158]

Fri, 03 September 2010 07:02

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

Senior Member

Then tell the users to enter the correct year!
a four digit year is a full year, 0010 is 0010. Oracle is not going to convert it for you. It'll only convert 2 digit years with the rr format mask.
Why don't you create a WHEN-VALIDATE-ITEM trigger and write a check to see if the date entered is older than a certain date and if it is raise an error.

Report message to a moderator