Home » Developer & Programmer » Forms » CHANGING DATE FORMAT IN FORMS
CHANGING DATE FORMAT IN FORMS [message #224740] Thu, 15 March 2007 05:15 Go to next message
ataufique
Messages: 79
Registered: November 2006
Member
I have change the date format in my database from DD-MON-YYYY
to DD/MM/YY.
But my forms are still showing old format,
Now where can i change in Forms setting such that it show new date format.
One way I found is format mask of each item, But this is not a
Global way.

IF any one knows, pls suggest how this can be done globally without changing in each and every forms.

Regards
Taufique A.
Re: CHANGING DATE FORMAT IN FORMS [message #225124 is a reply to message #224740] Sun, 18 March 2007 00:31 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
Anyone ?..
Re: CHANGING DATE FORMAT IN FORMS [message #225158 is a reply to message #225124] Sun, 18 March 2007 10:29 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Quote:

I have change the date format in my database from DD-MON-YYYY
to DD/MM/YY.



I think you can't change the date format in database such that it can be reflected in forms.

You'll have to change it in forms. You can use property Class feature in forms to make your changes in the form globally. But again for this purpose, you'll have to open the forms.

You can create one form and create a date item. Create a Property Class in that form and set the format mask of date item. Apply that property class to the item.

Now, open your forms where you want to set the format mask. Open Properties of the date item and Open Subclass Information. Select the form here you already created and select the property class. The format mask will be inheritted from that form's item which you created before.

You can assign this property to all your date items in your form.

I don't know any other way to set the format mask globally. May be someone will help if there is any other solution.

regards,
Saadat Ahmad

[Updated on: Sun, 18 March 2007 10:32]

Report message to a moderator

Re: CHANGING DATE FORMAT IN FORMS [message #225672 is a reply to message #225158] Tue, 20 March 2007 17:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

What version of Forms are you running? On what type of machine are you running your forms? The reference form suggestion given by Saadat is one the preferred methods, using an object library is the other.

David
Re: CHANGING DATE FORMAT IN FORMS [message #225973 is a reply to message #225672] Thu, 22 March 2007 02:39 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
Hi martin,

No this is not yet solved...
Better way till now what i found is go to the property of
date item and set format mask(one step), rather then what saadat suggested (create property class, open date item property and attach).
But what i am looking for is a global way as the above is not the better way to change in 42 forms(with an avg of 2 date items in each form).

Anyway thanks both for the help, I am using Forms 10g on 9i database, Windows platform.
Hope fully this could be considered in future version of Forms..

Pls suggest if there is any other solution to this.

Thanks & Regards,
Taufique Ahmed.
Re: CHANGING DATE FORMAT IN FORMS [message #226202 is a reply to message #225973] Thu, 22 March 2007 17:17 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You HAVE all of the free solutions about which I know.

  1. Open each form and specify the date format.
  2. Create a reference form, open each form and inherit the date format.
  3. Create a reference form with an object group, create an object library, drag the object group to the object library, open each form, drag in the object group from the object library and inherit the date format.

Alternatively (from memory) - FormsTool at http://www.orcl-toolbox.com/ has a facility to change things like this.

David

PS I am NOT affiliated with FormsTool but I did have extensive dealings with them on a previous project.
Re: CHANGING DATE FORMAT IN FORMS [message #226551 is a reply to message #226202] Sun, 25 March 2007 00:00 Go to previous message
ataufique
Messages: 79
Registered: November 2006
Member
Thanks David.

Regards,
Taufique Ahmed
Previous Topic: button to delete
Next Topic: Form Feed & Form Help (merged)
Goto Forum:
  


Current Time: Mon Dec 05 11:04:04 CST 2016

Total time taken to generate the page: 0.09381 seconds