Home » Developer & Programmer » Forms » Date Format in forms 10g (Oracle IAS 10g,Oracle Developer Suite 10g)
Date Format in forms 10g [message #332732] Wed, 09 July 2008 08:57 Go to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

I am in process to migrate forms 6i to forms 10g.I am getting the below problem:

Date field in forms 6i accepting date format as 'dd/mm/yyyy' without any format mask specification.But when form moved to 10g its not navigating out of that date field with displaying error "Frm-50026:Date must be enterned in format of 'DD-MON-YYYY'.I don't want to specify any format mask.I tried with alter nls_date_format with foms_ddl but no sucess.The form 10g running on the same DB as form 6i.

Is their any configuration settings that can resolve this issue.

Thanks

[Updated on: Wed, 09 July 2008 08:58]

Report message to a moderator

Re: Date Format in forms 10g [message #332770 is a reply to message #332732] Wed, 09 July 2008 11:12 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I don't want to specify any format mask

Why not? This is "Format mask" item property for:
Forms Builder
Display format and input accepted for data in display and text items
Re: Date Format in forms 10g [message #332775 is a reply to message #332770] Wed, 09 July 2008 11:46 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Thanks for reply
Actually We have 100s of forms.That means i need to search date field in every form to apply format mask.
Is their any other way like some config settings?

Typo

[Updated on: Wed, 09 July 2008 11:47]

Report message to a moderator

Re: Date Format in forms 10g [message #338751 is a reply to message #332775] Tue, 05 August 2008 20:56 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The 'alter' command was being applied to the database. You need to change the date format on the Application Server.

David
Previous Topic: problem in executing forms in 10g
Next Topic: forms layout and attaching calendar to a date field
Goto Forum:
  


Current Time: Sat Dec 10 18:46:55 CST 2016

Total time taken to generate the page: 0.10133 seconds