OraFAQ Forum: Forms » date validation problem

Home » Developer & Programmer » Forms » date validation problem

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

date validation problem [message #258648]

Mon, 13 August 2007 04:27

sauk
Messages: 29
Registered: June 2007

Junior Member

I am using oracle 10g forms.I 've a date field of type date.I want the used to enter date in any format(dd/mm/yyyy,dd.mm.yyyy).And in my 'when_validate_item trigger' I am converting the date to dd-mon-yyyy format.

I havent used any format mask, still it is giving an error 'date must be entered in dd-mon-yyyy format'.

Please could anyone help me to solve this.

Thanks,
Sera

[Updated on: Mon, 13 August 2007 04:29]

Report message to a moderator

Re: date validation problem [message #258658 is a reply to message #258648]

Mon, 13 August 2007 05:02

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

If you didn't use format mask then the default format of the date is dd-mon-yyyy. Another way to enter date in any format rather than using date field use text field and validate it using trigger. it will work fine.

Cheers
Sanka

Report message to a moderator

Re: date validation problem [message #258665 is a reply to message #258658]

Mon, 13 August 2007 05:22

sauk
Messages: 29
Registered: June 2007

Junior Member

Thanks a lot for the quick reply.its working now.

Sera

Report message to a moderator

Re: date validation problem [message #258698 is a reply to message #258648]

Mon, 13 August 2007 07:17

azamkhan
Messages: 557
Registered: August 2005

Senior Member

This is the default behavour of form. Which means a date format must be defined for date item. So if you dont define any format it will take the default format "dd-mon-yyyy".

You can do this by taking a varchar2 item allow the user to insert date in any format in that varchar2 item and you programatically copy that date with your format in the base table block. Smile

Report message to a moderator

Previous Topic:	Cannot see icon in runtime
Next Topic:	time problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:27:25 CDT 2024